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 <[email protected]> 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.
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
