Message-ID: <1513582586.2494.3.camel@cybertec.at>
Subject: Re: Postgres 10 shutting down on installation in Ubuntu 14
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Debraj Manna <subharaj.manna@gmail.com>, pgsql-admin
	 <pgsql-admin@postgresql.org>
Date: Mon, 18 Dec 2017 08:36:26 +0100
In-Reply-To: 
 <CAF6DVKNbwwgw35xObMo0WFcrjFJkub5SAZpqh+PZHFSk6ccSOQ@mail.gmail.com>
References: 
	<CAF6DVKNbwwgw35xObMo0WFcrjFJkub5SAZpqh+PZHFSk6ccSOQ@mail.gmail.com>
Organization: Cybertec
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: bulk

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 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?

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