Slony I - removing a replication set

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Slony I - removing a replication set
Date: 2007-12-20 13:49:19
Message-ID: 761323.85779.qm@web25804.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi people,

(I'm not sure how you lot feel about cross posting, but I've posted
this on the slony lists as well as here)

I setup a slony replication set for a table and subscribed my a node
to it. However in the slony log the subscriber shows :

2007-12-20 11:50:38 GMT ERROR remoteWorkerThread_1: node -1 not
found in runtime configuration
2007-12-20 11:50:38 GMT WARN remoteWorkerThread_1: data copy for
set 3 failed - sleep 15 seconds

I have no idea why this error has come about, the table I put in the
replication set exists on both the publisher and subscriber.

What I wanted to do was just drop the replication set from the
publisher and subscriber and try setting it up again.

I've done most of my setup using pgAdminIII, and it doesn't seem to
have an option to drop the set. I did at one point manage to drop the
set from the publisher, but it remained on the subscriber and I
couldn't drop it. So I recreated it on the publisher to see if it'd
help - to no avail and now I don't have the option to drop either.

Could someone tell me how I'd go about dropping it from both the
subscriber and the publisher?

A pointer to a guide to doing the stuff pgAdmin does manually might
be a help too.

Thanks
Glyn

___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
now.
http://uk.answers.yahoo.com/

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Nesheret 2007-12-20 14:40:00 Re: foreign key constraint, planner ignore index.
Previous Message Richard Huxton 2007-12-20 13:42:08 Re: foreign key constraint, planner ignore index.