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

Greg Sabino Mullane greg at endpoint.com
Fri Sep 5 13:14:54 UTC 2014

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140905/2b13216e/attachment.sig>

More information about the Bucardo-general mailing list