On 12/09/11 16:54, Toby Corkindale wrote:
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?
It's disappointing that I can't query standby_mode in psql. ie. SHOW standby_mode; Toby -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
