entrypoint_django

#!/bin/bash

set -o errexit
set -o pipefail
set -o nounset


postgres_ready() {
python << END
import sys
import psycopg2
import dj_database_url
DATABASE = dj_database_url.config('DATABASE_URL')
print(DATABASE)
try:
    psycopg2.connect(
        dbname=DATABASE["NAME"],
        user=DATABASE["USER"],
        password=DATABASE["PASSWORD"],
        host=DATABASE["HOST"],
        port=DATABASE["PORT"],
    )
except psycopg2.OperationalError:
    sys.exit(-1)
sys.exit(0)
END
}
until postgres_ready; do
  >&2 echo 'Waiting for PostgreSQL to become available...'
  sleep 1
done
>&2 echo 'PostgreSQL is available'

exec "$@"

healthcheck_pg.sh

#!/bin/bash
set -eo pipefail
# based on https://github.com/docker-library/healthcheck/blob/master/postgres/docker-healthcheck
# If the healthcheck is configured on the Dockerfile or docker-compose.yml
# use the docker inspect to show the healthcheck logs:
# docker inspect --format "{{json .State.Health }}" <container name> | jq

host="$(hostname -i || echo '127.0.0.1')"
user="${POSTGRES_USER:-postgres}"
db="${POSTGRES_DB:-POSTGRES_USER}"
export PGPASSWORD="${POSTGRES_PASSWORD:-}"

args=(
	# force postgres to not use the local unix socket (test "external" connectibility)
	--host "$host"
	--username "$user"
	--dbname "$db"
	--quiet --no-align --tuples-only
)

if select="$(echo 'SELECT 1' | psql "${args[@]}")" && [ "$select" = '1' ]; then
	echo "PostgreSQL is running as expected.";
	exit 0;
fi

echo "PostgreSQL is down.";
exit 1