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
1
vote
1 answer

bucardo customcols not working

I can't get bucardo customcols to work. Any help or advice will be greatly appreciated. I have 2 databases: - test_source - test_target Both databases only have 1 table (partner), the columns definition is: - id: integer (Primary key) - name:…
Aaron Neo
  • 11
  • 1
1
vote
1 answer

FATAL: password authentication when bucardo add tables

System specification: Ubuntu 14.04 bucardo version 4.99.10 psql (PostgreSQL) 9.3.14 What I have tried so far? I have created master database with openerp postgres user. - Setup Source Database export SOURCE_HOST=localhost export…
Bhavesh Odedra
  • 10,990
  • 12
  • 33
  • 58
1
vote
1 answer

bucardo unable to connect to other DBs

I experience some problems using bucardo add db command. It looks like it's unable to connect to other postgreSQL databases. I tried to do it in several ways. With pg_hba.conf setting "local" is for Unix domain socket connections only: local all…
MaterialGirl
  • 363
  • 2
  • 10
  • 22
1
vote
0 answers

Configuring bucardo for 3-master replication across high latency links?

I am new to bucardo and need to install it for database replication. The idea is to replicate 3 databases with the same content. I have a database which I will call it "db1" installed on a local machine. I have a second database and I will call it…
pmatos
  • 276
  • 4
  • 18
1
vote
1 answer

Bucardo add sync to replicate data

I am using Bucardo to replicate data in a database. I have one database, called mydb, and another called mydb2. They both contain identical tables, called "data" in both cases. Following the steps on this website, I have installed Bucardo and added…
rurouniwallace
  • 2,027
  • 6
  • 25
  • 47
0
votes
0 answers

ERROR: Invalid psql argument: must be full path to a file named psql

i try to monitor postgres 13 on windows 10 with the script check_postgres.pl of https://bucardo.org/downloads/check_postgres.pl.html#development. I have this error ERROR: Invalid argument: must be full path to a file nomed psql` however, I did…
WIll
  • 1
  • 1
0
votes
1 answer

PostgreSQL bucardo schema replication

I want to replicate all tables from specific PostgreSQL schemas. So new tables from these schemas to be added automatically in synchronization. Is it possible to do with Bucardo? If not, what tool would you recommend?
Alex
  • 265
  • 2
  • 15
0
votes
1 answer

How to get bucardo 5.6.0 to perform replication?

I'm trying to get Bucardo to perform multimaster replication between 2 postgres 12 databases. I believe that everything is installed correctly and I can configure replication. But, nothing happens. Below is a sample of the code I've tried (but…
JimF
  • 139
  • 2
  • 13
0
votes
1 answer

Bootstrap bucardo replication after pg_restore

Currently I am setting up Master/Master Replication with bucardo between 5 Nodes on different locations (should provide location transparency). The database holds ~500 Tables which should be replicated. I grouped them into smaller replication herds…
Jürgen Zornig
  • 1,174
  • 20
  • 48
0
votes
1 answer

PostgreSQL database replication failure because of duplicate key violation

I've configured two RHEL machines with redundancy configuration (master- master setup) with below software versions. Database: PostgreSQL 9.5 Bucardo: Bucardo 5.4 Database replication goes smoothly till some point of time, After that replication…
Prasad
  • 11
  • 4
0
votes
0 answers

Postgres and Replication

I am not too familiar with Bucardo and Postgres , so I was hoping to get some feedback / how to from this question. We have 3 computers running in parallel in various parts of the building. When one updates something the other shows the data…
Waddaulookingat
  • 337
  • 3
  • 16
0
votes
0 answers

bucardo sync issue, function does not exist

I have issues with adding database to sync. DB versions: PostgreSQL 9.6.8 (RDS), Jump system: Ubuntu18.04 LTS, bucardo version: 5.4.1. When trying run this command: bucardo add sync db_sync relgroup=copying_herd dbs=source_db:source,dest_db:target…
jozwior
  • 1
0
votes
2 answers

Removing a table from bucardo sync

I have two postgreSQL databases on two machines with Bucardo keeping them in sync. I have a particularly large table in the Postgres database which I don't want to have synced anymore, how do I tell bucardo to stop trying to sync it?
Ed.Whitaker
  • 1
  • 2
0
votes
3 answers

Problems with bucardo installation

I have postgresql 9.5 and postgresql-plperl-9.5 and bucardo version 5.4.1 after bucardo install Current connection settings: 1. Host: localhost 2. Port: 5432 3. User: postgres 4. Database: postgres 5. PID…
Meiram Chuzhenbayev
  • 898
  • 1
  • 10
  • 26
0
votes
2 answers

How to correctly add a primary key to databasechangelog(PostgreSQL) for Liquibase?

I try to migrate database from old PostgreSQL (9.3) to new PostgreSQL(9.5, 9.6) by Bucardo. Bucardo used Primary key for migrate. I have many databases with public.databasechangelog without Primary key. How correct add primary key to…
Anton Patsev
  • 605
  • 2
  • 13
  • 27
1
2
3