Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_last_xlog_receive_location() - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: pg_last_xlog_receive_location()
Date
Msg-id AANLkTikoeX6Hb3sMgwH=hxR8tF5rwwEH8NGJQSBdHLo7@mail.gmail.com
Whole thread Raw
In response to Re: pg_last_xlog_receive_location()  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: pg_last_xlog_receive_location()
List pgsql-hackers
Tree view 
On Wed, Mar 30, 2011 at 11:08 AM, Tatsuo Ishii <ishii@postgresql.org> wrote:
> BTW, is there any reliable way to know a standby is promoting to
> primary?

You can know that from the server log. But there is no way to do that
via SQL, I think.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Problem with streaming replication, backups, and recovery (9.0.x)
Next
From: Tatsuo Ishii
Date:
Subject: Re: pg_last_xlog_receive_location()