Re: Postgres 10 shutting down on installation in Ubuntu 14 - Mailing list pgsql-admin
On Sat, Dec 16, 2017 at 9:45 PM, Debraj Manna <subharaj.manna@gmail.com> wrote:
On trying to install postgres on Ubuntu 14 I am seeing postgres is shutting down. I am seeing the below errors in logs2017-12-16 02:41:40.657 PST [19043] LOG: listening on IPv4 address "127.0.0.1", port 54322017-12-16 02:41:40.660 PST [19043] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2017-12-16 02:41:40.675 PST [19044] LOG: database system was shut down at 2017-12-16 02:41:39 PST2017-12-16 02:41:40.681 PST [19043] LOG: database system is ready to accept connections2017-12-16 02:41:41.246 PST [19051] [unknown]@[unknown] LOG: incomplete startup packet2017-12-16 02:41:45.631 PST [19043] LOG: received fast shutdown request2017-12-16 02:41:45.637 PST [19043] LOG: aborting any active transactions2017-12-16 02:41:45.639 PST [19043] LOG: worker process: logical replication launcher (PID 19050) exited with exit code 12017-12-16 02:41:45.639 PST [19045] LOG: shutting down2017-12-16 02:41:45.664 PST [19043] LOG: database system is shut downCan some one let me know what could be going wrong?
You need to require following chnages in postgresql.conf file & set the listen_addresses = '*' aslo check whether the pg_hba.conf file has all the required entries and then restart the database server
pgsql-admin by date: