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 <[email protected]> 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 [email protected] > End Point Corporation > PGP Key: 0x14964AC8 > -- Regards, Juned Khan iNextrix Technologies Pvt Ltd. www.inextrix.com
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
