Christopher Browne cbbrowne
Fri Jun 17 15:35:43 PDT 2005
St?phane P?trot wrote:

> Hello,
>
> everything is in the subject : I want to reset my database which has
> been already modified by Slony. How to remove all the slony specifics
> entries in the database without doing that by hand (cluster shema,
> functions, trigger and so on...)? Is there a script to do that?
>
There is a slonik command specifically for that purpose:  UNINSTALL NODE.

You'll want to write a little slonik script:

cluster name=mycluster;
node 7 admin conninfo='host=host7 dbname=mydatabase';
uninstall node (id=7);

http://developer.postgresql.org/~wieck/slony1/adminguide-1.1.rc1/stmtuninstallnode.html


More information about the Slony1-general mailing list