Bug 19

Summary: fresh schema for a logshipped node - keeping triggers out
Product: Slony-I Reporter: Christopher Browne <cbbrowne>
Component: other scriptsAssignee: Slony Bugs List <slony1-bugs>
Status: RESOLVED FIXED    
Severity: normal CC: jpfletch, slony1-bugs
Priority: medium    
Version: devel   
Hardware: All   
OS: All   
URL: http://lists.slony.info/pipermail/slony1-general/2007-October/006763.html

Description Christopher Browne 2007-11-29 13:50:49 PST
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
Comment 1 Christopher Browne 2007-11-29 13:52:29 PST
Intention: To provide a script that may be run against a fresh log shipping
node (e.g. - with schema) to search out triggers on replicated tables and
suggest that the Gentle User consider dropping them.
Comment 2 Christopher Browne 2007-12-03 08:30:21 PST
Committed a new tool to search the source schema for triggers/rules.

http://lists.slony.info/pipermail/slony1-commit/2007-December/002102.html
http://lists.slony.info/pipermail/slony1-commit/2007-December/002101.html