[Bucardo-general] Problem with bytea on 4.5.0 and Postgres 9

2013-12-03 Thread Gustavo Tonini
Hello, I'm experiencing a data corruption in bytea fields using swap syncs. I made an update on DB A setting the value to \x373737. After replicate, DB B shows value \x78333733373337. Changing the parameter bytea_output to espace seems to work, but to change my application should be hard. How

Re: [Bucardo-general] Syncing a third master into the cluster

2016-01-26 Thread Gustavo Tonini
Pedro, Simply register the new node, add it in your sync creating a row on dbmap table and restart bucardo. Validate sync will do all the magic. I dont know if it is the official method but I have used it for years and never had problems. Gustavo. Em ter, 26 de jan de 2016 15:57, Pedro França

[Bucardo-general] Txntime should be commit time

2016-08-28 Thread Gustavo Tonini
Hey guys, I have an environment where the current implementation of txntime (set to transaction start time) is causing problems. It has long transactions so the conflict resolution strategy (latest) sometimes overwrites the real latest value (which belongs to the most recently committed

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

2021-03-09 Thread 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

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

2021-03-08 Thread 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 wrote:

Re: [Bucardo-general] General Issues Regaring Initial Setup

2021-02-18 Thread Gustavo Tonini
Hi Rodrigo, I saw some projects in which the install process is automated. This Dockerfile is an example of an automated installation of bucardo. Gustavo. On Thu, Feb 18, 2021 at 1:27 PM Rodrigo Rodovalho < rodrigo.rodova...@gmail.com> wrote: >