The client is a Hot Standby server. Regards, Abhijit
On Tue, Aug 22, 2017 at 11:05 AM, Michael Paquier <michael.paqu...@gmail.com > wrote: > On Tue, Aug 22, 2017 at 1:58 PM, Abhijit Gharami > <abhijitghar...@gmail.com> wrote: > > 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 > > One change introduced between 9.4.12 and 9.4.13 is the way WAL senders > are stopped at shutdown. The checkpointer will first send a signal to > all the WAL senders after all the normal backends have exited before > beginning to issue the checkpoint shutdown. This will switch the WAL > senders to a stopping state where all new queries are blocked, and all > WAL senders exit after they have sent any remaining WAL to the > clients, including the checkpoint shutdown record. So, what is the > client behind this WAL sender? It seems that this WAL sender is > waiting for some confirmation activity. > -- > Michael >