debugsqlMinor
Postgres 10 shutting down on installation in Ubuntu 14
Viewed 0 times
postgresubuntuinstallationshuttingdown
Problem
On trying to install postgres on Ubuntu 14 I am seeing postgres is shutting down. I am seeing the below errors in logs
Can some one let me know what could be going wrong? Why is postgres shutting down after the installation ?
[19043] LOG: listening on IPv4 address "127.0.0.1", port 5432
[19043] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
[19044] LOG: database system was shut down at 2017-12-16 02:41:39 PST
[19043] LOG: database system is ready to accept connections
[19051] [unknown]@[unknown] LOG: incomplete startup packet
[19043] LOG: received fast shutdown request
[19043] LOG: aborting any active transactions
[19043] LOG: worker process: logical replication launcher (PID 19050) exited with exit code 1
[19045] LOG: shutting down
[19043] LOG: database system is shut downCan some one let me know what could be going wrong? Why is postgres shutting down after the installation ?
Solution
-
listening on IPv4 address "127.0.0.1", port 5432, listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432", database system is ready to accept connections
Just your server starting up.
-
database system was shut down at 2017-12-16 02:41:39 PST
You always get this message at bootup, it's produced by the "expected state" of the write-ahead log manager.
-
incomplete startup packet
Nothing happened here.. a client buzzed in and then left., produced by a backend.
-
received fast shutdown request, aborting any active transactions, database system is shut down, worker process: logical replication launcher (PID 19050) exited with exit code 1
This is just the postmaster shutting down
listening on IPv4 address "127.0.0.1", port 5432, listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432", database system is ready to accept connections
Just your server starting up.
-
database system was shut down at 2017-12-16 02:41:39 PST
You always get this message at bootup, it's produced by the "expected state" of the write-ahead log manager.
-
incomplete startup packet
Nothing happened here.. a client buzzed in and then left., produced by a backend.
-
received fast shutdown request, aborting any active transactions, database system is shut down, worker process: logical replication launcher (PID 19050) exited with exit code 1
This is just the postmaster shutting down
Context
StackExchange Database Administrators Q#193325, answer score: 2
Revisions (0)
No revisions yet.