Home > mailing lists

Thread: Postgres 10 shutting down on installation in Ubuntu 14

Postgres 10 shutting down on installation in Ubuntu 14

From

Debraj Manna

Date:

16 December 2017, 22:15:11

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?

Re: Postgres 10 shutting down on installation in Ubuntu 14

From

Shreeyansh Dba

Date:

18 December 2017, 12:34:48

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

Re: Postgres 10 shutting down on installation in Ubuntu 14

From

Debraj Manna

Date:

18 December 2017, 12:55:15

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@gmail.com> wrote:

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

--

Re: Postgres 10 shutting down on installation in Ubuntu 14

From

Laurenz Albe

Date:

18 December 2017, 13:36:26

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