Wed Apr 29 14:16:23 PDT 2009
- Previous message: [Slony1-general] pgpass.conf for Windows Vista
- Next message: [Slony1-general] Revising Subscriptions
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
We are using Slony1 1.2.15 installed on 3 nodes and all of the
replicating tables are defined in one set. Currently we are set up so
that Node 1 is the Master, Node 2 is the receiver from Node 1, and Node
3 is the receiver from Node 2. So the data flows like this:
Node 1 --> Node 2 --> Node 3.
We used the following to set it up:
SUBSCRIBE SET (ID=1, PROVIDER=1, RECEIVER=2, FORWARD=yes);
SUBSCRIBE SET (ID=1, PROVIDER=2, RECEIVER=3, FORWARD=yes);
I want to change this so that Node 1 provides to both Nodes 2 and 3, and
I'd like to do
it so that we don't have to reload Node 3 from scratch (there's about 80
GB of data in the tables).
The data should flow like this:
Node 3 <-- Node 1 --> Node2
If I issue the slonik command:
SUBSCRIBE SET (ID=1, PROVIDER=1, RECEIVER=3, FORWARD=yes);
will this replace the subscription between Nodes 2 and 3 (which is what
I want) or will it replace the subscription between Nodes 1 and 2 (which
is what I don't want)?
I couldn't find a reference to this in the archives, if it does exists
please point me to it. Any help or insight into this would be
appreciated. Thanks.
Jay Janssen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090429/984fb7b1/attachment.htm
- Previous message: [Slony1-general] pgpass.conf for Windows Vista
- Next message: [Slony1-general] Revising Subscriptions
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list