Re: Who is Slony Master/Slave + general questions. - Mailing list pgsql-general

From sjarosz@gmail.com
Subject Re: Who is Slony Master/Slave + general questions.
Date
Msg-id 1169223921.422117.38880@m58g2000cwm.googlegroups.com
Whole thread Raw
In response to Re: Who is Slony Master/Slave + general questions.  ("Shoaib Mir" <shoaibmir@gmail.com>)
Responses Re: Who is Slony Master/Slave + general questions.
List pgsql-general
I am using LinuxHA to manage the failover and Slony as part of to
failover to move to the healthy node.  But my question was more along
the lines, if a user has access to both databases (master and slave)
but does not know which one is which, how can you tell?

Take a scenario: you configure 2 servers as master and slave.  You walk
for a period of time during which a number failovers occur.  You come
back.  Can I query a sl_???? table to determine which server is the
current master and which one is the current slave?

Thank you,

Slawek


pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: Password encryption method
Next
From: "Jan Muszynski"
Date:
Subject: Multiple column index question.