- Архив списков рассылки pgadmin-support

My objective is to setup and test replication, starting with a Master and Slave-1 server, and once
replication has worked, to add an additional Slave-2 server for replication. All of the replication
configuration was done strictly via pgAdmin3 v8.0-beta-5.
                            M                         /      \                        v        v
S1    S2 

After I have been successful at getting a simple master/slave replication setup to work, I proceeded
to add Slave-2 and noticed many unexpected replicaton objects additions added to both the Master
and Slave-1 configurations as well as to the new Slave-2 server as shown in the link to the jpg image
(of 36KB):

http://www.cdkkt.com/images/pgAdmin/replication1.jpg

Adding Slave-2 results:

======================
The Master now has two Replication Sets. The first "Hardware" set shows Sequences(0) as before,
the Tables(1) shows the public.cars object as before, and finally the Subscritions(1) shows the Slave
Node with the same properties as before.  So far it looks like there are no changes made here and all
looks good.

The second "Hardware" shows Subscriptions(0) under it.  Seems that I am unable to added a new
subscription here.

======================
As for Slave-1, the first "Hardware" set, Subscriptions(1) is shown directly under it, and directly under
Subscriptions(1) is the Slave Node.  Under Slave Node are two objects, Sequences(0) and Tables(0).
As for trying to create New Sequences or Tables, the only menu items available for these objects are:
"Refresh" and "object list report". However, New Subscriptions can be created at Subscriptions(1) or
at Slave Node.

The second "Hardware" set shows three objects: Sequences(0), Tables(0), and Subscriptions(0).
Choosing a New Table menu item will result in an empty list items for this table but you can type
whatever you want in the fields for this table, but you will not be able to commit it.  The same is
true for the Sequences(0).  A New Subscription can also be added but shows:

Orgin: 2
Provider: 2 - Slave Node
Receiver: 1 - Master Node, 5 - Slave Node (dropdown list)
Can Forward: Unchecked

You can OK to save these settings, but you cannot get rid of these once committed.

======================
As for Slave-2, and since we are adding a NEW slave here, two Hardware replication sets were
created.  The first shows "Hardware", with Subscriptions(1) having a Slave Node subscription
with:

Provider ID:       1
Provider Name:  Master Node
Receiver ID:       2
Recievier Name: Slave Node
Active:               Yes
May Forward:     Yes
Is forwarded:       No

Under the Slave Node object, there are two objects under this, and these are Sequences(0) and
Tables(0).  The only menu items for both of these objects are: "Refresh" and "object list report".
The second "Hardware" object shows only the Subscriptions(0) object.  Selecting New Subscription
shows:

Origin:          2
Provider:       5 - Slave Node
Reciever:      1 - Master Node, 2 - Slave Node (dropdown list)
Can forward: Unchecked

Clicking: OK shows an error:
"ERROR: Slony-I: subscribeSet(): provider 5 is not an active forwarding node for replication set 3"

Clicking: OK after selecting Reciever as: 2 - Slave shows error:
"ERROR: Slony-I: subscribeSet(): set origin and received cannot be identical"

Sequences and Tables branches was moved directly under 'Slave Node', as shown.  As for the additional
added Replication Sets with (0) Sequences, Tables, and Subscriptions, they cannot be deleted, the
missing tables and Sequences cannot be added, and Sequences, Tables, and Subscriptions cannot
be edited.

By the way, the Master to Slave-1 replication is still running fine at this time.  But I am unable to
get the Slave-2 replication configuation setup and joined to the replication group.

Hmm...  can someone tell me how it is possible to setup a Master and two-Slave replication via
pgAdmin3 and is it possible to do?

Thanks!
Dan

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.30/1030 - Release Date: 9/25/2007 8:02 AM