Attached are two patches related to the slony_extract_schema scripts.

1. Ensures that the major version of pg_dump matches the major version
of the postgresql backend your connecting to.  We've seen some problems
with using a newer pg_dump against an older backend where some GRANT
statements error out resulting in missing permissions on in the
extracted schema

2. A script to handle preparing a schema for upgrading to a newer
version of postgresql.  This script calls the slony1_extract_schema
script and then restores the dump to the database and uses the newer
pg_dump to produce a dump suitable for a newer version of postgresql.



-- 
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142


-- 
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
-------------- next part --------------
A non-text attachment was scrubbed...
Name: upgrade.diff
Type: text/x-patch
Size: 1699 bytes
Desc: not available
Url : http://lists.slony.info/pipermail/slony1-patches/attachments/20100324/28378e40/attachment.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: version_check.diff
Type: text/x-patch
Size: 1006 bytes
Desc: not available
Url : http://lists.slony.info/pipermail/slony1-patches/attachments/20100324/28378e40/attachment-0001.bin