(replication) Detecting if server a slave, or a master in recovery

From: Toby Corkindale <toby(dot)corkindale(at)strategicdata(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: (replication) Detecting if server a slave, or a master in recovery
Date: 2011-09-12 06:54:16
Message-ID: 4E6DAC98.3020100@strategicdata.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
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?

Thanks,
Toby

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Toby Corkindale 2011-09-12 07:09:53 Re: (replication) Detecting if server a slave, or a master in recovery
Previous Message Simon Riggs 2011-09-12 06:46:50 Re: servoy-postgresql plugin