On Fri, Sep 05, 2014 at 01:00:15PM +0530, Juned Khan wrote: > But whenever I am taking dump of my database I can see Bucardo related > functions and triggers in that dump file which conflicts and gives warning > at the time of import. So how do I remove them completely.
1) Nearly everything Bucardo related should be in the 'bucardo' schema, so you can tell pg_dump to exclude that schema: pg_dump mydbname --exclude-schema=bucardo 2) If you are doing a --data-only pg_restore, make sure you are using pg_restore's --disable-triggers option. 3) You could also only restore a specific (non-bucardo) schema by using pg_restore --schema=foobar ... 4) Finally, you can run pg_restore with the -l option, output that to a file, remove all the bucardo lines from it, and run pg_restore -L See the fine manual for details on that option. -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
