http://www.slony.info/bugzilla/show_bug.cgi?id=19

           Summary: fresh schema for a logshipped node - keeping triggers
                    out
           Product: Slony-I
           Version: devel
          Platform: All
               URL: http://lists.slony.info/pipermail/slony1-general/2007-
                    October/006763.html
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: medium
         Component: other scripts
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: cbbrowne at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


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 Fletcher, Afilias Canada


-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.