Stack Overflow
Stack Overflow

Questions tagged [bucardo]

Bucardo is an asynchronous trigger based replication system for PostgreSQL, with optional multi-master support.

See Bucardo.org.

Read the FAQ.

Do not attempt to use multi-master without understanding its limitations and reading the whole manual.

35 questions
6
votes
1 answer

glassfish throwing org.postgresql.xa.PGXAException

I am not really familiar with J2EE so I might make some mistakes while explaining the error. Please bear with me. I am trying to run a query over my java enterprise application but glassfish throws the following…
Alptugay
  • 1,676
  • 4
  • 22
  • 29
4
votes
1 answer

Would it be possible to do replication using bucardo between different postgresql versions?

We are having 2 database servers (Debian 8.3) with postgresql. 1st server having postgresql 8.4 and 2nd server is having postgresql 9.4. Would it be possible to setup bucardo between this 2 database servers? Please let me know. Any hint will be…
Samir Doshi
  • 41
  • 4
4
votes
2 answers

Postgres Sequence out of sync

I'm running a multi-master setup with bucardo and postgres. I'm finding that some of my table sequences are getting out of sync with each other. Particularly the auto-incremented id. example: db1 - table1 INSERT INTO distributors (did, dname) VALUES…
outrunthewolf
  • 125
  • 2
  • 12
3
votes
1 answer

Error "password authentication failed for user "bucardo" at /usr/local/bin/bucardo line 308" while adding postgresql database in bucardo

I have installed Bucardo in Linux server. However when I tried to add databases using the user "bucardo", I am unable to add it, I am getting the following error while adding databases. DBI…
Rajasekaran M
  • 163
  • 2
  • 16
3
votes
1 answer

How to handle sequences in Bucardo Postgresql multi master

We are setting up a database on three different Postgresql servers (and maybe on more in the future), currently syncing all tables using bucardo multi-master groups. We are not syncing sequences; we tried that, and we noticed bucardo is making us…
Mihnea Simian
  • 1,093
  • 1
  • 7
  • 13
2
votes
0 answers

Google Cloud SQL Postgres(Set Session_Replication_Role='Replica') || Bucardo

I'm trying to replicate the PostgresDB from AWS to GoogleCloudSQL using Bucardo in order to avoid live transactions. Here, Bucardo needs to set session_replication_role='replica' using user credentials on googlecloudsql postgres user. The postgres…
Satish Athukuri
  • 29
  • 5
2
votes
2 answers

Bidirectional Replication on Postgresql 9.3

I am using Postgres 9.3 on my production servers. I would like to achieve high availability of Postgres DB using Master-Master configuration where each master would run in an Active-Active mode with bidirectional replication. I have 2 Java Spring…
arnabkaycee
  • 1,634
  • 13
  • 26
2
votes
0 answers

Synchronize two postgresql databases with current data using with bucardo

I try to synchronize two databases using with bucardo. I create master to master replication and it works fine. However rows inserted before replication can not synchronize. I don't want dump one db to the other. How can I do that? Thanks for help.
umut
  • 1,016
  • 1
  • 12
  • 25
1
vote
2 answers

Postgres 15 Multi-Master Replication

For the last few days I've been trying to implement a working multi-master replication using postgresql however, unsuccessfull. I came across multiple tools, none of which as worked. I think I'm getting close to a solution but I'm hitting a…
João Ferreira
  • 58
  • 9
1
vote
0 answers

Docker Error : System has not been booted with systemd as init system (PID 1). Can't operate. Failed to connect to bus: Host is down

I was trying to write a Dockerfile to deploy PostgreSQL12 and Bucardo using Ubi8(RHEL8) as base images. My Dockerfile so far is below:- FROM redhat/ubi8 RUN yum update -y RUN yum install -y wget zip unzip \ && yum install -y…
Mrsk
  • 129
  • 5
  • 13
1
vote
0 answers

How do I know if bucardo making master to master or master to slave replication

I've created a sync via Bucardo for the first time using the following command: bucardo add sync test_sync relgroup=copying_herd dbs=source_test_db:source,dest_test_db:target onetimecopy=2 Now I want to be sure if I made a master-to-slave…
Meraj al Maksud
  • 1,528
  • 2
  • 22
  • 36
1
vote
1 answer

Primary-key collisions in multi-master replication environment using django

I have a multi-master replication setup using Postgres and Bucardo. On top of it, I have a Django application. The setup does not fully works since I keep getting primary-key collisions. Since the replication is configured to clone the whole…
rrb_bbr
  • 2,966
  • 4
  • 24
  • 26
1
vote
1 answer

Insert source data in target using bucardo

I want to create sync between two databases using bucardo. It's a one-way sync. Target and source are not identical(schema is same but data is different). I have setup sync with property onetimecopy=2 but logs shows has rows and we are in…
YogeshR
  • 1,606
  • 2
  • 22
  • 43
1
vote
1 answer

Bucardo shows wrong postgres version

I'm installing Bucardo to replicate my Postgres server (10.1) on openSUSE Leap 42.3, and I have successfully complied the executable of Bucardo. When I tried bucardo install and modified the parameter…
Ryan
  • 1,040
  • 3
  • 16
  • 25
1
vote
0 answers

How does bucardo work?

I setup Postgres Master to master replication using bucardo a few days back. It was working good till yesterday until I found an extremely rare issue. The issue was as follows. one table has auto-generated primary key. Someone Inserted a record in…
YogeshR
  • 1,606
  • 2
  • 22
  • 43
1
2 3