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

           Summary: slony1_extract.sh doesn't check the version of pg_dump
           Product: Slony-I
           Version: 1.2
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: low
         Component: core scripts
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: ssinger at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


tools/slony1_extract.sh uses the pg_dump (and psql) executables from the users
path.  It does not check to see that the pg_dump in your path matches the
version of the backend you are pointing to.

slony1_extract.sh will do a pg_dump (with options) against the backend and then
restore the schema against a temp database against the same backend.  Your
pg_dump binary must be from the same major postgresql version as the backend
your restoring to.   Using the 8.3 pg_dump to dump then restore to a 8.1
backend will not work (for sequence permissions won't get loaded).

This also means that you can't use the slony1_extract script to dump a schema
from one postgresql version on restore it on another.  You would have to load
the output of slony1_extract into the older pg backend and then do a second
dump with the newer pg_dump.

-- 
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.