Andrew Sullivan ajs at crankycanuck.ca
Tue Oct 2 11:38:23 PDT 2007
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


More information about the Slony1-general mailing list