Re: 1 Master and 2 Slaves... (Replication) - Mailing list pgadmin-support

From Daniel B. Thurman
Subject Re: 1 Master and 2 Slaves... (Replication)
Date
Msg-id 021126B987E43D44A860139823C079110E2B7D@orion.cdkkt.com
Whole thread Raw
In response to 1 Master and 2 Slaves... (Replication)  ("Daniel B. Thurman" <dant@cdkkt.com>)
List pgadmin-support
>
>I started out with a simple master and slave server
>arrangement and was successfully
>able to get the master to replicate to the slave. But once I
>added a second slave, things
>got much more confusing.
>
>I had assumed that adding replication to a second slave
>server, the relationship would
>remain between the second slave and the master and that the
>second slave would not
>know anything of the first slave and vice versa?
>
>I have noticed that adding a second slave, there were
>additional objects added to
>itself, the master, the first slave, and 1 additional
>subscription set, 1 additional slave nodes!
>
>In other words, the master and the slaves "know" about each other?
>
>This means that for every additional server being added, you
>have to go back and configure
>all of the other servers that "knows" about this new addition?
>
>The odd thing so far, my master/slave replication still works,
>but I wonder when the shite will
>hit the fan...
>
>Is there any documentation that explains this somehwhere?
>

Sorry for replying to my own post, but I forgot to mention that when
the second replication set was added, it seems that the original
replication set got corrutped on the slaves and the master seems to
have the table and sequence objects moved into the subscription tree
and for the additional replication set, it has no table object, no
sequence object, and simply cannot be removed or objects added to it.

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.28/1021 - Release Date: 9/21/2007 2:02 PM


pgadmin-support by date:

Previous
From: Charlie Clark
Date:
Subject: Re: Weird characters saved in SQL file
Next
From: Raymond O'Donnell
Date:
Subject: Re: 1 Master and 2 Slaves... (Replication)