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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
