pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres 10 shutting down on installation in Ubuntu 14
4+ messages / 3 participants
[nested] [flat]
* Postgres 10 shutting down on installation in Ubuntu 14
@ 2017-12-16 16:15 Debraj Manna <subharaj.manna@gmail.com>
2017-12-18 06:34 ` Re: Postgres 10 shutting down on installation in Ubuntu 14 Shreeyansh Dba <shreeyansh2014@gmail.com>
2017-12-18 07:36 ` Re: Postgres 10 shutting down on installation in Ubuntu 14 Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 2 replies; 4+ messages in thread
From: Debraj Manna @ 2017-12-16 16:15 UTC (permalink / raw)
To: pgsql-admin
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?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgres 10 shutting down on installation in Ubuntu 14
2017-12-16 16:15 Postgres 10 shutting down on installation in Ubuntu 14 Debraj Manna <subharaj.manna@gmail.com>
@ 2017-12-18 06:34 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2017-12-18 06:55 ` Re: Postgres 10 shutting down on installation in Ubuntu 14 Debraj Manna <subharaj.manna@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Shreeyansh Dba @ 2017-12-18 06:34 UTC (permalink / raw)
To: Debraj Manna <subharaj.manna@gmail.com>; +Cc: pgsql-admin
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​
--
[image: http://www.shreeyansh.com] <http://www.shreeyansh.com;
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgres 10 shutting down on installation in Ubuntu 14
2017-12-16 16:15 Postgres 10 shutting down on installation in Ubuntu 14 Debraj Manna <subharaj.manna@gmail.com>
2017-12-18 06:34 ` Re: Postgres 10 shutting down on installation in Ubuntu 14 Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2017-12-18 06:55 ` Debraj Manna <subharaj.manna@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Debraj Manna @ 2017-12-18 06:55 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: pgsql-admin
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​
>
>
>
> --
> [image: http://www.shreeyansh.com] <http://www.shreeyansh.com;
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgres 10 shutting down on installation in Ubuntu 14
2017-12-16 16:15 Postgres 10 shutting down on installation in Ubuntu 14 Debraj Manna <subharaj.manna@gmail.com>
@ 2017-12-18 07:36 ` Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 0 replies; 4+ messages in thread
From: Laurenz Albe @ 2017-12-18 07:36 UTC (permalink / raw)
To: Debraj Manna <subharaj.manna@gmail.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2017-12-18 07:36 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-12-16 16:15 Postgres 10 shutting down on installation in Ubuntu 14 Debraj Manna <subharaj.manna@gmail.com>
2017-12-18 06:34 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2017-12-18 06:55 ` Debraj Manna <subharaj.manna@gmail.com>
2017-12-18 07:36 ` Laurenz Albe <laurenz.albe@cybertec.at>
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