Debraj Manna 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
code1
> 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?
The database server is shutting down because somebody tells it to do that
by sending it a SIGINT signal.
That could be a user or a script running "pg_ctl stop".
You'll have to investigate who does that.
If it always happens soon after startup, perhaps the startup
script is at fault.
Yours,
Laurenz Albe