pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Debraj Manna <subharaj.manna@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Postgres 10 shutting down on installation in Ubuntu 14
Date: Mon, 18 Dec 2017 08:36:26 +0100
Message-ID: <1513582586.2494.3.camel@cybertec.at> (raw)
In-Reply-To: <CAF6DVKNbwwgw35xObMo0WFcrjFJkub5SAZpqh+PZHFSk6ccSOQ@mail.gmail.com>
References: <CAF6DVKNbwwgw35xObMo0WFcrjFJkub5SAZpqh+PZHFSk6ccSOQ@mail.gmail.com>

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




view thread (4+ messages)

Message-ID: <1513582586.2494.3.camel@cybertec.at>
Permalink:  ../1513582586.2494.3.camel@cybertec.at/
Also on:    postgresql.org/message-id/1513582586.2494.3.camel@cybertec.at

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: laurenz.albe@cybertec.at, subharaj.manna@gmail.com
  Subject: Re: Postgres 10 shutting down on installation in Ubuntu 14
  In-Reply-To: <1513582586.2494.3.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox