Slony Replication problem

From: "Slawek" <sjarosz(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Slony Replication problem
Date: 2007-02-13 21:04:40
Message-ID: 1171400680.712158.296880@q2g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I tring to set up Slony replication and am having issues with
repeatability.

Configuration: 2 nodes
Slony ver.: 1.2.6
OS: SuSE Linux 9.2

About 1/3 of the time, replication does not start properly. I think
I've traced it down to the fact that sometimes the second node is not
created properly in the prime db. I can see this by querying the
sl_node table where only 1 node (the prime) appears. On the backup
db, both nodes appear properly. To create the node, I'm using the
following slonik script

try {
echo 'Storing node 2';
store node (id = 2, comment = 'Node 2');
}
on error {
echo 'Could not create Node 2!';
exit -1;
}

No error is thrown when this code is ran, so as far as slonik script
is concerned everything is OK.

Questions:
1) What could be causing the second node to fail to be created? If
this is a timing issue, is there an event, or some data, I could check
to make sure that the 2nd node is ready to be created?
2) I discover that this error has occured after Slony is started on
both servers, and the replication set is subscribed to. If I have to
recreate this 2nd node on the prime server, what do I have to do?

Thank you,

Slawek

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Lambert 2007-02-13 21:42:24 Re: PGSQL 8.2.3 Installation problem
Previous Message Merlin Moncure 2007-02-13 20:58:10 Re: Using PITR for creating Hot Standby