On Fri, 2007-01-19 at 16:11 +0100, Sascha.Spreitzer at izb.de wrote:
> Can you explain why?
> How can a schema be left in an incorrect way if its being deleted?

Please reply to the list on all correspondence.

Slony does some ugly hacks to the subscribers (like re-points triggers
to indexes to disable them).  Dropping the schema like you've suggested
does not undo these changes.

Brad.


> -----Urspr?ngliche Nachricht-----
> Von: slony1-general-bounces at gborg.postgresql.org
> [mailto:slony1-general-bounces at gborg.postgresql.org] Im Auftrag von Brad
> Nicholson
> Gesendet: Freitag, 19. Januar 2007 15:40
> An: Sascha.Spreitzer at izb.de
> Cc: slony1-general at gborg.postgresql.org
> Betreff: Re: [Slony1-general] subscriber box drive failure....recovery
> 
> 
> On Fri, 2007-01-19 at 15:27 +0100, Sascha.Spreitzer at izb.de wrote:
> > Hello,
> > 
> > Drop the _<clustername> schema. (drop schema _<clustername>;)
> 
> This is the incorrect way to do it.  This can leave your schema in an
> inconsistent state.  There is a script to do this with (the name escapes
> me right now)
> 
-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.