Tue Oct 2 11:38:23 PDT 2007
- Previous message: [Slony1-general] fresh schema for a logshipped node
- Next message: [Slony1-general] slony-i + drbd
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Ugh. Surely JP's report is a P1 bug? A On Mon, Oct 01, 2007 at 03:55:17PM -0400, JP Fletcher wrote: > Hi, > > How is it that i'm supposed to get clean schema for a logshipped node? > I've previously pg_dumped form the log shipped node's provider, which is > itself a subscriber. On some dbs, however, i've run into the 'pg_dump > sanity check failed' issue when dumping from a subscriber, so I though > i'd try slony1_extract_schema.sh. This extracts schema fine from an > origin, but won't work for a log shipped node (i.e the output of > slony1_dump.sh won't apply) unless I manually drop all of the triggers > and constraints that are present on the origin... > > JP > _______________________________________________ > Slony1-general mailing list > Slony1-general at lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general -- Andrew Sullivan | ajs at crankycanuck.ca A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander Hamilton
- Previous message: [Slony1-general] fresh schema for a logshipped node
- Next message: [Slony1-general] slony-i + drbd
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list