Slony1 PostgreSQL Replication - Re: Replicating a table over 2 different subsriber

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Replicating a table over 2 different subsriber

cbbrowne-swQf4SbcV9C7WVzo/KQ3Mw@public.gmane.org

2006-01-16, 3:23 am

> On Fri, 2006-01-13 at 12:31 -0800, Alan Hodgson wrote:
>
> I came to the same conclusion about 5 minutes after I sent the email. I
> ended up dropping replication of the table and sequence, created a new
> set that had the one server as origin and the other 2 as subscribers,
> added the table and sequence to this new set and started subscribed the
> nodes. All worked well :-)

You could have handled this without dropping the table from replication...

Step 1. Create the new set, set #3

Step 2. It has no tables or sequences in it...

Step 3. Subscribe set 3 as many times as needed to allow it to have
identical subscribers to set #1

Step 4. Use MOVE SET to shift the table to set #3

Step 5. Revise subscriptions for set #3

If the table is small, then this isn't material...

Sponsored Links