On Fri, 2007-01-19 at 16:11 +0100, [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von Brad > Nicholson > Gesendet: Freitag, 19. Januar 2007 15:40 > An: [EMAIL PROTECTED] > Cc: [email protected] > Betreff: Re: [Slony1-general] subscriber box drive failure....recovery > > > On Fri, 2007-01-19 at 15:27 +0100, [EMAIL PROTECTED] 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. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
