Geek Answers Handbook

Postgres shuts down immediately on startup using docker-compose

Postgres immediately shuts down at startup using docker-compose. The yaml file used is located below

version: '2' services: postgres: image: postgres:9.5 container_name: local-postgres9.5 ports: - "5432:5432"

Logging on docker-compose up

 Creating local-postgres9.5 Attaching to local-postgres9.5 local-postgres9.5 | The files belonging to this database system will be owned by user "postgres". local-postgres9.5 | This user must also own the server process. local-postgres9.5 | local-postgres9.5 | The database cluster will be initialized with locale "en_US.utf8". local-postgres9.5 | The default database encoding has accordingly been set to "UTF8". local-postgres9.5 | The default text search configuration will be set to "english". local-postgres9.5 | local-postgres9.5 | Data page checksums are disabled. local-postgres9.5 | local-postgres9.5 | fixing permissions on existing directory /var/lib/postgresql/data ... ok local-postgres9.5 | creating subdirectories ... ok local-postgres9.5 | selecting default max_connections ... 100 local-postgres9.5 | selecting default shared_buffers ... 128MB local-postgres9.5 | selecting dynamic shared memory implementation ... posix local-postgres9.5 | creating configuration files ... ok local-postgres9.5 | creating template1 database in /var/lib/postgresql/data/base/1 ... ok local-postgres9.5 | initializing pg_authid ... ok local-postgres9.5 | initializing dependencies ... ok local-postgres9.5 | creating system views ... ok local-postgres9.5 | loading system objects' descriptions ... ok local-postgres9.5 | creating collations ... ok local-postgres9.5 | creating conversions ... ok local-postgres9.5 | creating dictionaries ... ok local-postgres9.5 | setting privileges on built-in objects ... ok local-postgres9.5 | creating information schema ... ok local-postgres9.5 | loading PL/pgSQL server-side language ... ok local-postgres9.5 | vacuuming database template1 ... ok local-postgres9.5 | copying template1 to template0 ... ok local-postgres9.5 | copying template1 to postgres ... ok local-postgres9.5 | syncing data to disk ... ok local-postgres9.5 | local-postgres9.5 | WARNING: enabling "trust" authentication for local connections local-postgres9.5 | You can change this by editing pg_hba.conf or using the option -A, or local-postgres9.5 | --auth-local and --auth-host, the next time you run initdb. local-postgres9.5 | local-postgres9.5 | Success. You can now start the database server using: local-postgres9.5 | local-postgres9.5 | pg_ctl -D /var/lib/postgresql/data -l logfile start local-postgres9.5 | local-postgres9.5 | **************************************************** local-postgres9.5 | WARNING: No password has been set for the database. local-postgres9.5 | This will allow anyone with access to the local-postgres9.5 | Postgres port to access your database. In local-postgres9.5 | Docker default configuration, this is local-postgres9.5 | effectively any other container on the same local-postgres9.5 | system. local-postgres9.5 | local-postgres9.5 | Use "-e POSTGRES_PASSWORD=password" to set local-postgres9.5 | it in "docker run". local-postgres9.5 | **************************************************** local-postgres9.5 | waiting for server to start....LOG: database system was shut down at 2016-05-16 16:51:54 UTC local-postgres9.5 | LOG: MultiXact member wraparound protections are now enabled local-postgres9.5 | LOG: database system is ready to accept connections local-postgres9.5 | LOG: autovacuum launcher started local-postgres9.5 | done local-postgres9.5 | server started local-postgres9.5 | ALTER ROLE local-postgres9.5 | local-postgres9.5 | local-postgres9.5 | /docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/* local-postgres9.5 | local-postgres9.5 | LOG: received fast shutdown request local-postgres9.5 | LOG: aborting any active transactions local-postgres9.5 | LOG: autovacuum launcher shutting down local-postgres9.5 | LOG: shutting down local-postgres9.5 | waiting for server to shut down....LOG: database system is shut down local-postgres9.5 | done local-postgres9.5 | server stopped local-postgres9.5 | local-postgres9.5 | PostgreSQL init process complete; ready for start up. local-postgres9.5 | local-postgres9.5 | LOG: database system was shut down at 2016-05-16 16:51:55 UTC local-postgres9.5 | LOG: MultiXact member wraparound protections are now enabled local-postgres9.5 | LOG: database system is ready to accept connections local-postgres9.5 | LOG: autovacuum launcher started

Postgres seems to work fine when the container starts using the same image using docker run

 docker run --name local-postgres9.5 -p 5432:5432 postgres:9.5
+5
source share
2 answers

I tried your docker layout, and work in the container:

 root@0afe99de0f0b :/# ps aux USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND postgres 1 0.5 0.8 227148 16128 ? Ss 14:42 0:00 postgres postgres 74 0.0 0.0 227148 1768 ? Ss 14:42 0:00 postgres: checkpointer process postgres 75 0.0 0.0 227148 1772 ? Ss 14:42 0:00 postgres: writer process postgres 76 0.0 0.0 227148 1768 ? Ss 14:42 0:00 postgres: wal writer process postgres 77 0.0 0.1 227576 2720 ? Ss 14:42 0:00 postgres: autovacuum launcher process postgres 78 0.0 0.0 82132 1888 ? Ss 14:42 0:00 postgres: stats collector process root 79 2.0 0.0 21820 1984 ? Ss 14:42 0:00 /bin/bash root 84 0.0 0.0 19092 1296 ? R+ 14:42 0:00 ps aux

Anyway, for my project I use a different image for postgresql: https://github.com/sameersbn/docker-postgresql . It works great.

+1
source

If you look at the log output, the following lines will appear at the end of the line:

 local-postgres9.5 | server stopped local-postgres9.5 | local-postgres9.5 | PostgreSQL init process complete; ready for start up.

Obviously, stopping and restarting the Postgres server is part of the initialization process. In fact, the second to last line says

 local-postgres9.5 | LOG: database system is ready to accept connections.
+3
source

More articles:


All Articles