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

[Juned Khan]

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>
wrote:

> 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
>



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