[Bucardo-general] Remove Bucardo triggers and functions completely in dump file

Juned Khan jkhan6722 at gmail.com
Fri Sep 5 13:22:06 UTC 2014

Thank you Greg for reply. If everything Bucardo related is in 'bucardo'
schema then first option is fine for me.

On Fri, Sep 5, 2014 at 6:44 PM, Greg Sabino Mullane <greg at endpoint.com>

> 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 greg at endpoint.com
> End Point Corporation
> PGP Key: 0x14964AC8

Juned Khan
iNextrix Technologies Pvt Ltd.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140905/0ae14552/attachment.html>

More information about the Bucardo-general mailing list