On Tue, Mar 29, 2011 at 9:08 PM, Tatsuo Ishii <is...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
