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
>
> 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.
On Tue, 9 Mar 2021 at 14:12, Gustavo Tonini wrote:
> Lucas,
> In order to work properly, Bucardo needs to set the parameter
> "session_replication_role" (which disables triggers, FKs and checks) for
> each node in the replication session.
>
> I think this is not possible in a managed RDS
Lucas,
In order to work properly, Bucardo needs to set the parameter
"session_replication_role" (which disables triggers, FKs and checks) for
each node in the replication session.
I think this is not possible in a managed RDS instance.
Gustavo.
On Mon, Mar 8, 2021, 22:05 Lucas Possamai wrote:
On Mon, 8 Mar 2021 at 19:42, Lucas Possamai wrote:
> Hi all.
>
> I am migrating a live PostgreSQL 9.2 database to RDS PostgreSQL 12.4,
> using Bucardo.
>
> I remember reading somewhere months ago that I should disable the triggers
> of the target database, but unfortunately, I cannot find that
