René-Etienne Muscat remuscat at gmail.com
Tue Sep 2 02:59:42 PDT 2008
Today I tried the *UNINSTALL NODE* on the server, but it was unsuccessful!
It returned:
PGRES_FATAL_ERROR select "_test_cluster".uninstallNode();  - ERROR:
Slony-I: alterTableRestore(): Table with id 300 not found

Should I go to the *drop schema <cluster name> cascade;* or is there another
slonik command I can use?

Regards,
Rene

On Tue, Aug 26, 2008 at 5:01 PM, Jan Wieck <JanWieck at yahoo.com> wrote:

> On 8/20/2008 5:46 AM, Martin Eriksson wrote:
>
>> Yes it will,
>>
>> the cascade will remove ALL slony triggers.
>>
>> I do it all the time..
>>
>
> Note that before Slony 2.0 this is a perfect recipe for disaster as this
> method does not restore the system catalog to a sane state in case Slony =
had
> disabled user triggers, foreign key constraints or rewrite rules.
>
> The recommended way to remove Slony from a subscriber is to use the slonik
> command UNINSTALL NODE.
>
>
> Jan
>
> --
> Anyone who trades liberty for security deserves neither
> liberty nor security. -- Benjamin Franklin
>
>
> _______________________________________________
> 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/20080902/=
086dc6db/attachment.htm


More information about the Slony1-general mailing list