Slony1 PostgreSQL Replication - How to remove slony entries database?

Author

How to remove slony entries database?

Stéphane Pétrot

2005-06-17, 9:24 am

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?

Thanks!
Stéphane

Christopher Browne

2005-06-17, 9:24 am

St=E9phane P=E9trot 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=3Dmycluster;
node 7 admin conninfo=3D'host=3Dh
ost7 dbname=3Dmydatabase'
;
uninstall node (id=3D7);

http://developer.postgresql.org/~wi...1.rc1/stmtunin=
stallnode.html

Tang, Jason

2005-06-17, 11:25 am

Hi

I think I sent this a few days ago in response to one of your queries :-)

Jase

slonik <<_EOF_
cluster name = $CLUSTER;

node 1 admin conninfo = 'dbname=$DBNAME1 host=$HOST1 user=$SLONY_USER';
node 2 admin conninfo = 'dbname=$DBNAME2 host=$HOST2 user=$SLONY_USER';
uninstall node ( id = 1 );
uninstall node ( id = 2 );
_EOF_

-----Original Message-----
From: slony1-general-bounces- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org [mailto:slony1-general-bounces- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org] On Behalf Of Stéphane Pétrot
Sent: 17 June 2005 15:24
To: slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org
Subject: [Slony1-general] How to remove slony entries database?

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?

Thanks!
Stéphane

Sponsored Links