Re: How to reliably detect if it's a promoting standby

Ok, it seems impossible to do that by using any public interfaces
currently available in PostgreSQL 9.0. I will create a custom C
function to be distributed along with pgpool-II.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi,
>
> I'm looking for a way to reliably detect if it's a promoting
> standby. This is neccessary for pgpool-II manage streaming replication
> clusters. When primary goes down, standby *could* start promoting to
> primary. The only way to find it is calling
> pg_is_in_recovery(). Problem is, it returns true even if standby is
> promoting. If pgpool-II waits for cetain period, it may finishes
> promotion, thus it returns false. But how long should we wait?
>
> Any idea?
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers