-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ravi Chemudugunta a écrit :
> Hi all,
> 
> I was wondering if it was possible to remove slony from the output of
> pg_dump.  I am currently accomplishing something similar with
> --excludeschema _cluster (where all the slony stuff is) but all of the
> triggers on replicated tables are still there.
> 
> It would be good if I could do something like uninstallnode() from
> within a transaction and dump the db schema from within the context ...
> 
> does anyone have any good ideas on how I can do this?
> 
> -ravi

Hi,

First, you have to execute the dump on the master.
Second, you can use some tool like slony1_dump.sh or so.

Personnaly, I do copy the schema of my master DB in a temp DB and execute a
uninstallnode() on that temp DB, before I do a drop schema _STHG cascade.

Hope that helps.

Regards,
- --
Stéphane Schildknecht
PostgreSQLFr - http://www.postgresql.fr
Dalibo - http://www.dalibo.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJCsjCA+REPKWGI0ERAkjxAKCTIAdh6lbDWFNKXT5Y7vkN0eCakQCgt50K
uHkeNVTqlT9Hwx3+uXB3UNM=
=nwd/
-----END PGP SIGNATURE-----