On Tue, Aug 22, 2017 at 1:58 PM, Abhijit Gharami <abhijitgharami@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
