[Bucardo-general] Bucardo source as Slave server

[David Christensen]

> Hi,
> 
> I want to replicate data from Postgresql Slave to another Postgresql. In this case, Im using 1 separate server for Bucardo. So will get the data from Slave and replicate it to other PostgreSQL server?
> 
> The architecture will look like this.
> 
> PostgreSQL Master --> PostgreSQL slave Server --> Bucardo server --> new postgresql server
> 
> Thanks,
> Bhuvanesh R.

Hi Bhuvanesh,

Triggers do not fire on standby servers, nor are they writable to track delta rows, so this cannot work on a slave.  You have to run this on a master server.

Best,

David
--
David Christensen
End Point Corporation
david at endpoint.com
785-727-1171



-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20190122/f8f2b77c/attachment.sig>