On 12/09/11 17:13, Simon Riggs wrote:
On Mon, Sep 12, 2011 at 7:54 AM, Toby Corkindale
<toby.corkind...@strategicdata.com.au>  wrote:

What is the correct way to tell what mode a replicated Pg server is
currently in, via a database connection?

I can take a guess if it's the master or a slave by using the
pg_current_xlog_location() and pg_last_xlog_replay_location() functions.

However it occurs to me that a master server, which has been roughly
rebooted and is replaying its WAL files will probably give the same response
as a slave, when I call the current_xlog_location().


What is the best method for determining whether you're connected to the
master or slave database?

SELECT pg_is_in_recovery();


If I'm on a master database, which had previously crashed and is now in the process of recovery, won't that also return "true" there?

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to