Hi All,

I have a Slony slave that I wish to perform some pg_dumps as backups 
from to restore elsewhere for testing. But I don't want the slony schema 
or triggers to come in the dump.

my dump right now is like follows:

pg_dump dbname --schema=myschema1 --schema=myschema2

Since I'm specifying specifically two schemas, the slony schema is not 
included. However, the slony triggers on the tables within the schemas I 
do want to copy are part of the dump. So when I run a restore, it 
attempts to create those triggers. The triggers do fail because the 
slony schema and elements don't exist, but I don't like the idea of 
having a ton of failures in my restoration when restoring this database.

Is there any way in the dump to also exclude slony objects that exist 
out of the slony schema?

Thanks,

- Brian F