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
>
>