Martin Eriksson m.eriksson at albourne.com
Wed Aug 20 02:46:55 PDT 2008
Yes it will,

the cascade will remove ALL slony triggers.

I do it all the time..


René-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é-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
>
>



More information about the Slony1-general mailing list