From: | "Shoaib Mir" <shoaibmir(at)gmail(dot)com> |
---|---|
To: | "sjarosz(at)gmail(dot)com" <sjarosz(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Who is Slony Master/Slave + general questions. |
Date: | 2007-01-20 06:07:57 |
Message-ID: | bf54be870701192207j206858c1uc7900ecf095ebb29@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I dont have the replication setup on my machine right now but I guess as far
as I remember you can surely check for the master and slave nodes from a
Slony schema table.
------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 19 Jan 2007 08:25:23 -0800, sjarosz(at)gmail(dot)com <sjarosz(at)gmail(dot)com> wrote:
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Shoaib Mir | 2007-01-20 06:23:00 | Re: Installing Postegres side-by-side with M$ SQL server |
Previous Message | Matthew T. O'Connor | 2007-01-20 05:30:50 | Re: Help : Microsoft SQL Server equivalents in |