This will be a short one.
The official Postgres Docker image supports a few environment variables. One of them, POSTGRES_DB, is responsible for ho...
For further actions, you may consider blocking this person and/or reporting abuse
Anyone ever run into permission issues running the script?
For example:
server started
/usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/create-multiple-postgres-databases.sh
/usr/local/bin/docker-entrypoint.sh: /docker-entrypoint-initdb.d/create-multiple-postgres-databases.sh: /bin/bash: bad interpreter: Permission denied
Well... in case any other poor soul stumbles onto this problem, you have to set the script as executable because Docker copies over permissions...
I created an account just to thank you
😂 Your welcome!
I also created an account just to thank you
I also created an account just to thank you
i've already done that. but still no database created
You'll need to then run
docker-compose up -d
again and if needed, create your new database from an sql script.I figure out this problem with change volume config. Don't attach whole
/docker-entrypoint-initdb.d
directory as volume. Then not permitted a directory copied to container. Solution was add all files one by one. like below;The server seems to shut down when the DBs are created
Multiple databases created
LOG: received fast shutdown request
waiting for server to shut down...LOG: aborting any active transactions
LOG: autovacuum launcher shutting down
.LOG: shutting down
LOG: database system is shut down
done
server stopped
PostgreSQL init process complete; ready for start up.
Thanks for sharing this!
Wondering if you found anything else since you wrote this article that may be helpful or did you end up sticking with the approach you wrote here?