From: | Abhijit Gharami <abhijitgharami(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org |
Subject: | Fwd: PostgreSQL 9.4.13 is facing issue in shutting down |
Date: | 2017-08-22 04:58:41 |
Message-ID: | CAA5_DuD0O1XyM8OnOzhRepyPU-t8nZKLzs1pT2JpzP0NS+vVNA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-bugs pgsql-general |
Hi,
Recently we have updated our PostgreSQL version from 9.4.12 to 9.4.13. With
version 9.4.13 while trying to stop the PostgreSQL server, database is
facing issues in shutting down. The problem probably occurs because of the
WAL sender process not getting terminated on shutdown request.
ps output:
postgre+ 7915 0.0 1.9 589772 39528 ? S< 09:11 0:00
/..../bin/postgres -D /.../postgresql -h 0.0.0.0 -p 5432
postgre+ 8617 0.0 0.4 590760 8344 ? S<s 09:13 0:00 postgres:
wal sender process replicator xx.xx.xx.xxx(45948) streaming 0/4000090
Sequence of events in log:
FATAL: terminating connection due to administrator command
LOG: received fast shutdown request
LOG: aborting any active transactions
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
We are using pg_ctl fast mode to shutdown the postgres server.
Regards,
Abhijit
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2017-08-22 05:35:45 | Re: Fwd: PostgreSQL 9.4.13 is facing issue in shutting down |
Previous Message | Abhijit Gharami | 2017-08-21 10:26:57 | PostgreSQL 9.4.13 is facing issue in shutting down |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2017-08-22 05:35:45 | Re: Fwd: PostgreSQL 9.4.13 is facing issue in shutting down |
Previous Message | 691525127 | 2017-08-22 03:02:41 | BUG #14789: In Cascading Replication,the "wal_level" is setted to "archive",the operation becomes abnomal |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2017-08-22 05:35:45 | Re: Fwd: PostgreSQL 9.4.13 is facing issue in shutting down |
Previous Message | Dylan Luong | 2017-08-22 04:11:49 | Re: pg_rewind - restore new slave failed to startup during recovery |