1

On trying to install postgres on Ubuntu 14 I am seeing postgres is shutting down. I am seeing the below errors in logs

[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 down

Can some one let me know what could be going wrong? Why is postgres shutting down after the installation ?

  • 1
    What's the question specifically? – Evan Carroll Dec 17 '17 at 4:13
2
  • 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

  • Thanks Evan. Can you please explain a bit more about the last bullet logical replication launcher exited. What is impacted if postmaster is shut down? How can I get more info why postmaster is shutting down? – tuk Dec 18 '17 at 6:30
  • Postmaster shuts down as part of systemd. Exit code 1 from the worker, just shows that it should not be restarted back up. It got the signal to shut down, and it did. Exit code 0 would be session termination (as compared to top-down shut down request from init.) – Evan Carroll Jun 8 '18 at 14:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.