Questions tagged [postgresql-bdr]

Bi-Directional Replication (BDR) PostgreSQL extension to enable asynchronous multi-master replication.

Filter by
Sorted by
Tagged with
1
vote
0answers
426 views

BDR error :ERROR: could not open extension control file

BDR error : when making changes to the postgresql.conf for shared_preload_libraries = ’pglogical,bdr’ ``FATAL: could not access file "pglogical": No such file or directory``` also cannot make ...
1
vote
0answers
232 views

Postgresql BDR - What causes replication_slots to go inactive?

I'm trying to hunt down what causes replication slots to go inactive. Might seem like a remedial question but I'm noticing that on my master database server, I have many inactive replication slots ...
1
vote
1answer
316 views

How to Loadbalance a Postgres BDR Cluster

I'm planning to use BDR (by 2ndQuadrant) to setup a multi master cluster for my PostgreSQL Databases. how can i achieve real loadbalancing for read and write Operations? I dont want to do it on the ...
1
vote
1answer
579 views

Postgresql BDR Update Update conflict detection

Apparently only the new values of rows are sent between nodes on update. So how can there ever be detectable conflict? Node A receives an update from Node B, and a different update from node C. ...
1
vote
1answer
65 views

Ensuring Postgresql BDR replication

My understanding, reading between the lines, is that BDR replicates row by row, starting after the COMMIT. I have a requirement to be able to then wait until some nodes have actually replicated my ...
0
votes
1answer
261 views

2ndQuadrant BDR installation not working anymore

I previously used the following to install BDR (9.4) on Ubuntu: echo "deb http://packages.2ndquadrant.com/bdr/apt/ trusty-2ndquadrant main" > "/etc/apt/sources.list.d/2ndquadrant.list" wget --...
1
vote
1answer
114 views

Postgresql BDR problem compiling pluging

I'm trying to build deb packages for postgresql BDR plugin, but I'm getting the following error: gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-...
1
vote
1answer
255 views

Postgres Row Level Security and BDR

I am implementing a multi tenant web app using postgres. I want to use Row Level Security (RLS ) for data separation. RLS is available from PG version 9.5. However, at the same time, the HA / DR teams ...
0
votes
1answer
96 views

Procedure to replace a BDR server

I have set up a 2-node PG 9.4 system with BDR. Replication works great. Now, let's suppose that one of the two nodes needs to be replaced. In fact, let's be more specific. Let's say that the node on ...
1
vote
0answers
414 views

BDR Replication issue

I am trying to setup 2-node BDR replication and i am getting the following error while running bdr_init_copy. /usr/pgsql-9.4/bin/bdr_init_copy -d "host=10.10.145.111 dbname=apimgtdb port=5432" -U ...
2
votes
1answer
429 views

postgresql bdr 0.8.x - adding another downstream server only partially works

I have the following postgresql 9.4 bdr setup: upstream server with db called "bdrdemo" running on 10.1.1.1 downstream server(1) with db called bdrdemo running on 10.2.2.2 (replicates with 10.1.1.1) ...
2
votes
1answer
1k views

postgresql 9.4 + BDR Fails [closed]

I'm trying to get postgresql 9.4 and BDR working. Following this tutorial: https://wiki.postgresql.org/wiki/BDR_Quick_Start Actually, my sysadmin provided me with a package to test with. He's taken ...
2
votes
1answer
914 views

Can bdr only replicate one database per server?

I have installed the new BDR-Solution with PostgreSQL 9.4 and it works like a charm. My Problem: I want to add more databases to the replication but every time if I added the other database and ...