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
