Re: Postgres 10 shutting down on installation in Ubuntu 14

[Debraj Manna <subharaj.manna@xxxxxxxxx>]

Is there a way I can get more info about why postgresql is getting shutdown ? Right now the postgresql log is not providing much information.

On Mon, Dec 18, 2017 at 12:04 PM, Shreeyansh Dba <shreeyansh2014@xxxxxxxxx> wrote:

On Sat, Dec 16, 2017 at 9:45 PM, Debraj Manna <subharaj.manna@xxxxxxxxx> wrote:

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

2017-12-16 02:41:40.657 PST [19043] LOG:  listening on IPv4 address "127.0.0.1", port 5432

2017-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 PST

2017-12-16 02:41:40.681 PST [19043] LOG:  database system is ready to accept connections

2017-12-16 02:41:41.246 PST [19051] [unknown]@[unknown] LOG:  incomplete startup packet

2017-12-16 02:41:45.631 PST [19043] LOG:  received fast shutdown request

2017-12-16 02:41:45.637 PST [19043] LOG:  aborting any active transactions

2017-12-16 02:41:45.639 PST [19043] LOG:  worker process: logical replication launcher (PID 19050) exited with exit code 1

2017-12-16 02:41:45.639 PST [19045] LOG:  shutting down

2017-12-16 02:41:45.664 PST [19043] LOG:  database system is shut down

Can 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​

--