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