35 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
2
votes
2
answers
11k
views
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 ...
2
votes
0
answers
9k
views
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 ...
0
votes
0
answers
200
views
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 ...
0
votes
1
answer
536
views
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 ...
1
vote
0
answers
126
views
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 ...
1
vote
1
answer
413
views
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 ...
0
votes
1
answer
289
views
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. ...
0
votes
1
answer
999
views
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 ...
1
vote
1
answer
1k
views
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 ...
0
votes
0
answers
65
views
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 ...
0
votes
0
answers
406
views
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=...
1
vote
1
answer
412
views
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=...
4
votes
0
answers
599
views
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 ...
0
votes
2
answers
2k
views
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 ...
1
vote
1
answer
522
views
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 ...