Asynchronous bi-directional (multi-master) replication built in to PostgreSQL 9.4 and above
Questions tagged [postgresql-bdr]
27 questions
20
votes
3 answers
PostgreSQL & BDR: Is BDR truly multi-master, is it Open Source and EOL for 1.x in 2019?
I am confused regarding PostgreSQL BDR and I have several questions:
Question 1: Is BDR truly multi-master for PostgreSQL?
According to the docs here, it says that:
The BDR (Bi-Directional Replication) project adds multi-master
replication to…

Ted
- 19,727
- 35
- 96
- 154
6
votes
1 answer
How good is BDR for production Postgres sync?
I have a system where multiple satellites create financial transactions and they need to sync up with a core server. The satellites are remote servers that run Rails apps with a local Postgres database. The core is another Rails app with its own…

Jenna S
- 616
- 1
- 6
- 24
4
votes
1 answer
Database is locked against ddl by another node in postgresql BDR
I have installed 2nd Quadrant PostgreSQL BDR version 1.0.2-2017-10-31- in three AWS nodes in different regions for Active-Active replication. Replication has worked fine as when I imported data in database of one node it replicated to other node.…

Debasish Bishnu
- 41
- 3
4
votes
0 answers
How do I alter sequences in Postgres with BDR
We are doing some database migration in Postgres (in two-node BDR cluster).
Because of some unrelated issue, sequence on certain tables are out of sync and need to be reset.
We tried the setval (and ALTER SEQUENCE) but both failed.
SELECT…

user965692
- 181
- 2
- 8
4
votes
2 answers
Django 1.8 Migration with Postgres BDR 9.4.1
I am trying to run Django migrations on a Postgres database with BDR.
python manage.py makemigrations
works fine, but running
python manage.py migrate
results in the following error:
ALTER TABLE … ALTER COLUMN TYPE … may only affect UNLOGGED or…

keda
- 559
- 2
- 12
4
votes
1 answer
Joining Postgres BDR Node Uses Outdated DSN
I have a cluster of Postgres BDR that has 3 nodes "Ready" and 3 nodes "Parted".
If I do SELECT * FROM bdr.bdr_nodes the following information is displayed:
-[ RECORD 1 ]------+-------------------------
node_sysid |…

Tk421
- 6,196
- 6
- 38
- 47
3
votes
1 answer
How do I get a Golang Database connection pool to manage connections to multiple hosts in a cluster?
I'm setting up bi-direction replication between four PostgreSQL workers, and I'd like to have my Go database connection pool handle connections to all four. It ought to be able to create multiple connections to them all, randomly select one for any…

theory
- 9,178
- 10
- 59
- 129
3
votes
0 answers
Postgresql replication: using 2 BDR with/and 2*n UDR or pglogical (some kind of DataCenter setup)
I plan to run a replicated Postgresql over multiple sites. There should be two servers on every site. At the main site they should run in BDR mode. And between the sites (to the other servers) I need something like UDR.
I could use BDR if it would…

A. Binzxxxxxx
- 2,812
- 1
- 21
- 33
2
votes
0 answers
Custom guc variables not set properly
I am trying to set a string variable say 'bdr_node_name' in the terminal using set command.
bdrdemo=# set bdr.node_name = 'node1';
SET
bdrdemo=# show bdr.node_name ;
bdr.node_name
---------------
node1
(1 row)
Steps followed:
1)In…

RRR
- 81
- 1
- 10
2
votes
0 answers
ERROR: establish BDR: FATAL: no pg_hba.conf entry for replication connection from host "[local]", user "postgres"
I get this below error while trying to set up BDR when both the nodes are on different hosts.
SELECT bdr.bdr_group_join(local_node_name := 'node2',node_external_dsn := 'port=5599 dbname=bdrdemo host= user=postgres', join_using_dsn :=…

Sree
- 21
- 3
2
votes
1 answer
Make PostgreSQL BDR work without superuser (postgres user) privileges?
We're switching from MongoDB to Postgres at work, and I'm setting up a BDR group.
At this step I'm looking at security and locking down where possible. Hence, I was hoping to set up a replication user (role) and let BDR use that for its replication…

DanielSmedegaardBuus
- 977
- 1
- 10
- 18
1
vote
0 answers
Django + PostgreSQL with bi-directional replication
Firstly please let me introduce my use-case: I am working on Django application (GraphQL API using Graphene), which runs in the cloud but also have its local instances in local customer's networks.
For example One application in the cloud and 3…

Jakub Dubec
- 77
- 1
- 11
1
vote
1 answer
what is better in my case Postgres BDR or Postgres-XL?
Currently I am working on making the 2 node cluster of PostgreSQL on bare metal cloud. I am very confused about either which approach should I go.
Like i have one option that is PostgreSQL BDR (bi directional replica). In this approach, I have…

Amad
- 314
- 1
- 6
- 25
1
vote
1 answer
bdr_init_copy hangs indefinitely
Fairly new to Postgresql, but have to get replication set up. I settled on BDR, and it works fine in the local demo, but on distributed machines it starts to get problematic, mostly because I have no real clue what the hell I am doing, and I cry…

devilsansclue
- 179
- 1
- 9
1
vote
1 answer
How to migrate data from non-bdr pgsql to bdr pgsql
I have fusionpbx with simple pgsql working ... Now i have created HA fusionpbx with bdr pgsql and it is working fine but I don't know how to migrate data from non-bdr pgsql to bdr pgsql ...

tj59
- 31
- 5