Jeff Frost jeff at frostconsultingllc.com
Mon Sep 22 07:56:28 PDT 2008
Knight, Doug wrote:
>
> 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?
>
>
JF: The configuration will actually be pushed around when you run the
slonik setup script.  Uninstall node must be run for each node and it
must be run for the master last.  You could put all these in the same
script.  I don't think the slon daemon running is required for uninstall
node, but I'm not 100% positive of this.  Perhaps one of the core
developers could answer this one.

> 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?
>
>  =

>
JF: That's correct.

-- =

Jeff Frost, Owner 	<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/=
a797578d/attachment-0001.htm


More information about the Slony1-general mailing list