Re: pg_stat_replication when standby is unreachable

Abhishek Rai <abhishekrai@gmail.com> writes:
>   SELECT * from pg_stat_replication();
>
> I've noticed that when I terminate the standby (cleanly or through kill
> -9), the result of above function goes from 1 row to zero rows.  The result
> comes back to 1 row when the standby restarts and reconnects.  I was
> wondering if there is any kind of guarantee about the results of
> pg_stat_replication as the standby suffers a network partition, and/or
> restarts and reconnects with the primary.  Are there any parameters that
> control this behavior?

Not that I know of. We don't register standbies at all, so the master
only knows about those which are successfully connected now.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support