onjin/docker-compose.yml

Created September 5, 2016 09:17

Star (154) You must be signed in to star a gist
Fork (25) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/onjin/2dd3cc52ef79069de1faa2dfd456c945.js"></script>
Save onjin/2dd3cc52ef79069de1faa2dfd456c945 to your computer and use it in GitHub Desktop.

Download ZIP

example docker compose for postgresql with db init script

Raw

docker-compose.yml

	postgres:
	image: postgres:9.4
	volumes:
	- ./init.sql:/docker-entrypoint-initdb.d/init.sql

Raw

create table sometable(id int);

DavidGameDev commented Mar 14, 2025

I'm running into an issue where my db init process is in fact running in the container, at least batching a bunch of CREATES and INSERTS of my dump data, but then is abruptly shut down and restarted.
strends_psql | CREATE DATABASE
strends_psql | You are now connected to database "rivers" as user "usr".
strends_psql | CREATE SCHEMA
strends_psql | SET
strends_psql | SET
strends_psql | SET
strends_psql | SET
strends_psql | SET
strends_psql | SET
strends_psql | SET
strends_psql | CREATE TABLE
strends_psql | INSERT 0 4
strends_psql |
strends_psql |
strends_psql | 2019-04-29 17:43:06.633 UTC [41] LOG:  received fast shutdown request
strends_psql | waiting for server to shut down....2019-04-29 17:43:06.637 UTC [41] LOG:  aborting any active transactions
When I get a shell into my db container, the database rivers was created but is empty, with no tables, relations, or data from my batched inserts.
The same issue

Same problem aswell

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment