PostgreSQL 9.4.13 is facing issue in shutting down

From: Abhijit Gharami <abhijitgharami(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: PostgreSQL 9.4.13 is facing issue in shutting down
Date: 2017-08-21 10:26:57
Message-ID: CAA5_DuCBF5vxtde1ZHCdRxuG+kQd9YiZ6_DJru4ZEjCrDXPkNg@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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Abhijit Gharami 2017-08-22 04:58:41 Fwd: PostgreSQL 9.4.13 is facing issue in shutting down
Previous Message David G. Johnston 2017-08-18 21:37:06 Re: pg_dump and pg_restore to dropbox

Browse pgsql-bugs by date

  From Date Subject
Next Message fujimoto 2017-08-21 10:44:39 BUG #14788: `pg_restore -c` won't restore schema access privileges.
Previous Message fadheljmuhammad 2017-08-21 09:08:11 BUG #14787: Postgresql_for_odoo

Browse pgsql-general by date

  From Date Subject
Next Message marcelo 2017-08-21 13:54:23 Re: Selecting some schema not suported for libpq PQconnectdbParams
Previous Message Dylan Luong 2017-08-21 07:53:46 pg_rewind - restore new slave failed to startup during recovery