docker-entrypoint.sh

#!/bin/bash
set -e

set_listen_addresses() {
	sedEscapedValue="$(echo "$1" | sed 's/[\/&]/\\&/g')"
	sed -ri "s/^#?(listen_addresses\s*=\s*)\S+/\1'$sedEscapedValue'/" "$PGDATA/postgresql.conf"
}

if [ "$1" = 'postgres' ]; then
	mkdir -p "$PGDATA"
	chmod 700 "$PGDATA"
	chown -R postgres "$PGDATA"

	# look specifically for PG_VERSION, as it is expected in the DB dir
	if [ ! -s "$PGDATA/PG_VERSION" ]; then
		su-exec postgres initdb

		# check password first so we can output the warning before postgres
		# messes it up
		if [ "$POSTGRES_PASSWORD" ]; then
			pass="PASSWORD '$POSTGRES_PASSWORD'"
			authMethod=md5
		else
			# The - option suppresses leading tabs but *not* spaces. :)
			cat >&2 <<-'EOWARN'
				****************************************************
				WARNING: No password has been set for the database.
				         This will allow anyone with access to the
				         Postgres port to access your database. In
				         Docker's default configuration, this is
				         effectively any other container on the same
				         system.
				         Use "-e POSTGRES_PASSWORD=password" to set
				         it in "docker run".
				****************************************************
			EOWARN

			pass=
			authMethod=trust
		fi

		{ echo; echo "host all all 0.0.0.0/0 $authMethod"; } >> "$PGDATA/pg_hba.conf"

		# internal start of server in order to allow set-up using psql-client
		# does not listen on TCP/IP and waits until start finishes
		su-exec postgres pg_ctl -D "$PGDATA" \
			-o "-c listen_addresses=''" \
			-w start

		: ${POSTGRES_USER:=postgres}
		: ${POSTGRES_DB:=$POSTGRES_USER}
		export POSTGRES_USER POSTGRES_DB

		if [ "$POSTGRES_DB" != 'postgres' ]; then
			if [ -n "$POSTGRES_DB_CREATE" ]; then
				psql --username postgres <<-EOSQL
					${POSTGRES_DB_CREATE} ;
EOSQL
			else
	      if [ -n "$POSTGRES_ENCODING" ] && [ -n "$POSTGRES_COLLATE" ] && [ -n "$POSTGRES_COLLATE_TYPE" ]; then
	        readonly encoding="'"$POSTGRES_ENCODING"'"
	        readonly collate="'"$POSTGRES_COLLATE"'"
	        readonly collate_type="'"$POSTGRES_COLLATE_TYPE"'"
	        psql --username postgres <<-EOSQL
	           CREATE DATABASE "$POSTGRES_DB" WITH ENCODING $encoding LC_COLLATE $collate LC_CTYPE $collate_type TEMPLATE template0 ;
EOSQL
	      else
					if [ -n "$POSTGRES_ENCODING" ]; then
						readonly encoding="'"$POSTGRES_ENCODING"'"
						psql --username postgres <<-EOSQL
						 CREATE DATABASE "$POSTGRES_DB" WITH ENCODING $encoding ;
EOSQL
					else
				  	psql --username postgres <<-EOSQL
				     CREATE DATABASE "$POSTGRES_DB" ;
EOSQL
					fi
	      fi
			fi
			echo
		fi

		if [ "$POSTGRES_USER" = 'postgres' ]; then
			op='ALTER'
		else
			op='CREATE'
		fi

		psql --username postgres <<-EOSQL
			$op USER "$POSTGRES_USER" WITH SUPERUSER $pass ;
		EOSQL
		echo

		psql+=( --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" )

		echo
		for f in `ls -d /docker-entrypoint-initdb.d/* | sort`; do
			case "$f" in
				*.sh)  echo "$0: running $f"; . "$f" ;;
				*.sql)
					echo "$0: running $f";
					psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < "$f"
					echo
					;;
				*)     echo "$0: ignoring $f" ;;
			esac
			echo
        done

		su-exec postgres pg_ctl -D "$PGDATA" -m fast -w stop
		set_listen_addresses '*'

		echo
		echo 'PostgreSQL init process complete; ready for start up.'
		echo
	fi

	exec su-exec postgres "$@"
fi

exec "$@"