See comments interspersed below:

 

________________________________

From: Jeff Frost [mailto:jeff at frostconsultingllc.com] 
Sent: Saturday, September 20, 2008 5:28 PM
To: Knight, Doug
Cc: slony1-general at lists.slony.info
Subject: Re: [Slony1-general] Instructions for setup of slony pair

 

Knight, Doug wrote: 

List,

I've been looking at the sample instructions for setting up a
replication pair. Unfortunately the sample on the web site is for two
databases on the same host (the pgbench example). There are no details
on what runs where (i.e. do I run the setup script on both nodes? If so,
do I run the same script on both nodes, or are there differences?).
Also, I don't see any instructions for how to "undo", in case of an
error during the setup. I was seeing:

 

Error: name space already exists...

 

Any help would be greatly appreciated.

Doug,

The setup script is run from any location with slonik installed that can
connect to all the nodes.  Slonik then connects to the database on each
node and does the work.  to uninstall, see the uninstall node command
here: http://slony.info/documentation/stmtuninstallnode.html
DK: So I only run the script on a single node, probably the origin, and
when I bring up slon on each node it will handle pushing the
configuration around? To run UNINSTALL NODE, does the slon process need
to be running on the origin? Does it need to be running on the target
too, and does uninstalling on the origin uninstall on the target?


You can also just drop the slony cluster schema.  For instance if your
cluster is called mycluster, then you would:

DROP SCHEMA _mycluster CASCADE;

to drop it.  You have to do that on all nodes before starting over
again.
DK: This is from psql, not slonik, right?

 

Thanks for your help,

Doug



-- 
Jeff Frost, Owner      <jeff at frostconsultingllc.com>
<mailto:jeff at frostconsultingllc.com> 
Frost Consulting, LLC  http://www.frostconsultingllc.com/
Phone: 916-647-6411    FAX: 916-405-4032
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080922/6381f142/attachment.htm