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
>

Reply via email to