[Bucardo-general] From PG 9.2 to 12.4 - Bucardo questions

[Gustavo Tonini]

Lucas,
if the parameter works in RDS, you can perfectly have a multimaster setup
and write to any DB that belongs to the sync. The data will be replicated
to the other nodes of the sync.

*session_replication_role* is a session parameter that is only set by
bucardo when it copies the modified data among the nodes so bucardo delta
triggers are not activated creating an infinite loop of data replication.
Your application will run with *session_replication_role*=false, so when it
changes something, bucardo triggers will be activated marking the rows to
be replicated in delta tables and notifying bucardo server to replicate the
changes.

Gustavo.

On Mon, Mar 8, 2021 at 11:33 PM Lucas Possamai <drum.lucas at gmail.com> wrote:

> Gustavo, I did not find that information about the
>> *session_replication_role* online. Where is that on Bucardo's website?
>>
>> Lucas
>>
>
> Okay.. looking at that parameter better, it is safer to activate that than
> disabling triggers. It is possible to activate that parameter on RDS as
> well. Looks like Bucardo needs to update their documentation.
>
> However, I still do not know if I can have a multi-master setup, but at
> the same time, having an application pointed to the target_db writing data.
> Probably not since *session_replication_role* will be enabled.
>
> Lucas
>


-- 
Gustavo.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210309/16523da9/attachment.htm>