[Bucardo-general] Sync from one table to many, but conditioned by a column with database destination

Greg Sabino Mullane greg at endpoint.com
Thu May 28 02:25:16 UTC 2015


On Mon, May 25, 2015 at 05:36:49PM +0200, Guido Brugnara wrote:
> I need to synchronize a table that contains a column with the name of the target database.
> So in the table there are lines that go replicated in different databases.

That is going to be tricky. Yes, it may be possible with a well-written 
customcode. At the very least, you would need to have all the databases 
pre-defined as targets. Then the customcode would limit the rows before 
they were written to each target.

> I must also solve the inverse problem; to synchronize master tables 
> that have different databases towards a slave only table that has a 
> column with the name of the database of origin.

Should be possible as well.

-- 
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/20150527/3038a8f9/attachment.sig>


More information about the Bucardo-general mailing list