Questions tagged [postgresql-bdr]

Asynchronous bi-directional (multi-master) replication built in to PostgreSQL 9.4 and above

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.…
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…
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…
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
1
2