[Bucardo-general] Using a hot standby as source
Greg Sabino Mullane
greg at endpoint.com
Fri Aug 1 16:37:00 UTC 2014
On Fri, Aug 01, 2014 at 11:04:13AM -0400, Riaan Ahmed wrote:
> Is it necessary to have read-write enabled on the source?
Yes. Triggers need to track which rows are enabled. Even if you
shift the triggers to the master, Bucardo still needs to write
to certain tables so it knows which rows have been replicated.
(It's possible Bucardo may gain the ability to use the logical
new log streaming feature in the future and thus avoid source
triggers, but that will have its own tradeoffs and limitations.)
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 163 bytes
Desc: Digital signature
More information about the Bucardo-general