[Bucardo-general] Replication to a different schema

Csaba Simon simocsab at gmail.com
Sat Feb 9 16:23:37 UTC 2013


Thanks for your quick answer. I use bucardo_ctl to configure replication
and it does not know "customname" option. Should I have a "bucardo"
executable? Where can I find it and its documentation?


On 9 February 2013 17:17, Greg Sabino Mullane <greg at endpoint.com> wrote:

> On Sat, Feb 09, 2013 at 03:19:20PM +0100, Csaba Simon wrote:
> > Hi,
> >
> > I would like to replicate a table to a schema with different name, I mean
> > schema name of the table in target database differs from the source
> schema
> > name. I found the term "customname" in glossary of Bucardo documentation,
> > but I cannot find how to use it. Or should I use "customcode" feature?
> How
> > does it work?
> Yes, customname is what you want. If the source database has a table
> named public.foobar and you want the target database (let's call it B)
> to receive things in the "sales" schema, you would run:
> bucardo add customname public.foobar sales.foobar db=B
> --
> Greg Sabino Mullane greg at endpoint.com
> End Point Corporation
> PGP Key: 0x14964AC8
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130209/2a8e8271/attachment.html>

More information about the Bucardo-general mailing list