[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...
Size: 163 bytes
Desc: Digital signature
More information about the Bucardo-general