On Tue, Mar 29, 2011 at 9:08 PM, Tatsuo Ishii <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
