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