On Tue, Mar 29, 2011 at 9:08 PM, Tatsuo Ishii <ishii@postgresql.org> wrote:
>> In the primary server which was brought up from the standby,
>> pg_last_xlog_receive_location() returns non-NULL.
>
> Thanks.
>
> BTW, is there any reliable way to know a standby is promoting to
> primary?
if you know the server was a standby and pg_is_in_recovery() returns
false then it was promoted.
is that what you want to know? or i misunderstood you?
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL