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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
