Sun May 16 05:22:38 PDT 2010
- Previous message: [Slony1-hackers] License info hard to find
- Next message: [Slony1-hackers] [Slony1-bugs] Slony triggers included in pg_dump
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi All, The docs here http://www.slony.info/documentation/triggers.html says that post Postgres 8.3 version <snip> - If you take a pg_dump of a Slony-I node, and drop out the Slony-Inamespace, this now cleanly removes *all* Slony-I components, leaving the database, *including its schema,*in a "pristine", consistent fashion, ready for whatever use may be desired. </snip> But I see that when dumping a schema containing tables monitored by Slony, the dump still shows the log triggers on those tables. postgres=# select version(); version ---------------------------------------------------------------------------------------------------- PostgreSQL 8.3.10 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.3.2 20081105 (Red Hat 4.3.2-7) # pg_dump --schema-only --schema pgbench -p 5433 -U postgres | grep "CREATE TRIGGER" CREATE TRIGGER _pgbench_logtrigger_1 CREATE TRIGGER _pgbench_logtrigger_2 CREATE TRIGGER _pgbench_logtrigger_3 So is that statement in the docs incorrect, or is this a regression? Best regards, -- gurjeet.singh @ EnterpriseDB - The Enterprise Postgres Company http://www.enterprisedb.com singh.gurjeet@{ gmail | yahoo }.com Twitter/Skype: singh_gurjeet Mail sent from my BlackLaptop device -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-hackers/attachments/20100516/fabd4530/attachment.htm
- Previous message: [Slony1-hackers] License info hard to find
- Next message: [Slony1-hackers] [Slony1-bugs] Slony triggers included in pg_dump
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-hackers mailing list