Abhishek Rai <abhishek...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
