Joe Conway mail at joeconway.com
Wed Oct 24 13:23:28 PDT 2012
In the fine manual it says:

    "If you pg_dump your database avoid dumping your Slony schemas or
     else pg_dump's locking will compete with Slony's own locking which
     could stop Slony replication for the duration of the pg_dump.
     Exclude the Slony schemas from pg_dump with
     --exclude-schema=schemaname to specifically exclude your Slony
     schema."

Question: if I exclude dumping the slony schema, how can I successfully
restore my tables? My tables all have dependencies on the slony
triggers, which will then be missing when I go to restore the tables.

Thanks,

Joe


-- 
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support


More information about the Slony1-general mailing list