Thanks both of you for your support. I will try it on a test machine before
doing it live.
Best Regards,
Rene


On 8/20/08, Shahaf Abileah <shahaf at redfin.com> wrote:
>
> I agree.  It does remove all the triggers.  I also do it regularly.  More
> specifically, I generally use slonik commands to unsubscribe and remove
> slave nodes, and then I use the "drop schema" command to clean up the mas=
ter
> node.
>
> --S
>
> -----Original Message-----
> From: slony1-general-bounces at lists.slony.info [mailto:
> slony1-general-bounces at lists.slony.info] On Behalf Of Martin Eriksson
> Sent: Wednesday, August 20, 2008 2:47 AM
> Cc: slony1-general at lists.slony.info
> Subject: Re: [Slony1-general] Dropped Master Cluster
>
> Yes it will,
>
> the cascade will remove ALL slony triggers.
>
> I do it all the time..
>
>
> Ren=E9-Etienne Muscat wrote:
> > But this will not remove the triggers from the tables! Is there a
> > clean way of getting this done or is this the only method?
> >
> > Thanks for your help,
> > Rene
> >
> > On Wed, Aug 20, 2008 at 10:51 AM, Martin Eriksson
> > <m.eriksson at albourne.com <mailto:m.eriksson at albourne.com>> wrote:
> >
> >     on the slaves nodes issue:
> >
> >     drop schema <cluster name> cascade;
> >
> >     this will remove ALL slony stuff from the database it is run on.
> >
> >     /martin
> >
> >
> >     Ren=E9-Etienne Muscat wrote:
> >
> >         Hi everyone, I have dropped the master cluster from pgadmin
> >         and cannot do the same to the slave cluster.
> >         What can I do to remove this replication set from the slave
> >         and get the tables back to normal?
> >         P.S. I have other replication sets working fine, so I do not
> >         want to do any changes that would affect the other replication
> >         sets.
> >          Rene
> >
> ------------------------------------------------------------------------
> >
> >         _______________________________________________
> >         Slony1-general mailing list
> >         Slony1-general at lists.slony.info
> >         <mailto:Slony1-general at lists.slony.info>
> >         http://lists.slony.info/mailman/listinfo/slony1-general
> >
> >
> >
> >     _______________________________________________
> >     Slony1-general mailing list
> >     Slony1-general at lists.slony.info
> >     <mailto:Slony1-general at lists.slony.info>
> >     http://lists.slony.info/mailman/listinfo/slony1-general
> >
> >
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080820/=
8337b054/attachment-0001.htm