Wed Oct 24 13:23:28 PDT 2012
- Previous message: [Slony1-general] manual replication
- Next message: [Slony1-general] pg_dump, slony databases, and locking
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] manual replication
- Next message: [Slony1-general] pg_dump, slony databases, and locking
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list