On 12-10-24 04:23 PM, Joe Conway wrote: > 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. >
Yes the CREATE TRIGGER commands in the restore will fail with errors, but if your restore isn't done as part of a transaction then it leaves you with a working database, with data minus slony triggers. You could also filter your schema dump through grep to exclude the triggers. > Thanks, > > Joe > > _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
