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

[Gustavo Tonini]

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 <drum.lucas at gmail.com> wrote:

> On Mon, 8 Mar 2021 at 19:42, Lucas Possamai <drum.lucas at gmail.com> 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
>> information anymore.
>>
>> The business wants to slowly move customers to the PG 12.4 RDS database.
>> The idea was to modify the application and check if it's *customer_id X,
>> Y and Z*, write data to RDS and not current PG 9.2.
>>
>> My question is:
>> Can I have bucardo replicating data from PG 9.2 to RDS 12.4 and at the
>> same time, have customers writing data to RDS? Of course that means I'd
>> have to re-enable triggers on my target DB?
>>
>>
> I remembered Bucardo does multi-master replication. Tried to look on the
> internet how to set it up, but apparently, my RDS PG 12 is already
> considered a "master". So I think there is no reason for me to disable the
> triggers on the target_db. Again, I do not remember where I read this.
>
> Waiting for someone to confirm this...
>
> Lucas
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://bucardo.org/mailman/listinfo/bucardo-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210308/fca72dc3/attachment.htm>