How to add additional users and databases?

[phlegx]

I can add additionally users and database with psql as soon as the postgres server is started. With this docker image the binary is started via docker-entrypoint.sh How can I automate this within my own Dockerfile?

I assume I would need to write a script that I call within my Dockerfile as an entrypoint. This script would need to start the database server, then execute the commands with psqland afterwards stop the db server again and let the original docker-entrypoint.sh entrypoint taken place. However I'm not sure: how can I start and stop a postgres server manually within my custom script with this postgres docker image?

thanks
m

[phlegx]

Ok I think I simply need to hack into the docker-entrypoint.sh and replace the original!

[tianon]

See

postgres/docker-entrypoint.sh

Lines 63 to 67 in bfca9b8

	if [ -d /docker-entrypoint-initdb.d ]; then
	for f in /docker-entrypoint-initdb.d/*.sh; do
	[ -f "$f" ] && . "$f"
	done
	fi

for an easy way to accomplish this without replacing the entire entrypoint script. 👍

[uksus70]

Is it possible to do it using SQL script inside /docker-entrypoint-initdb.d ?

[xtimon]

#240

[gmile]

@uksus70 per comment #240 (comment) it is possible, yes (I didn't test though)

[wglambert]

Since this issue seems unrelated to any errors in the image itself, and being a year without further comment, I'm going to prune the issue.
If you believe this to be in error then let me know and I'll re-open it

Given that the issue is more of a usability question, it would be more suited for the Docker Community Forums, the Docker Community Slack, or Stack Overflow.