Questions tagged [postgres-bdr]
4 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
1
vote
1 answer
Postgres - BDR replication - problem with auto_increment primary key
I have a cluster of Postgres BDR that has 2 nodes (multi master replication).
I've created a table with auto increment primary key as follow:
create table t1 (id serial primary key, name text);
I've added some values on that table from…
user7416080
0
votes
0 answers
Recovering from broken foreign key leftovers on postgresql
We have a very simple one-to-many relation. site and resolver tables. resolver has a foreign key for site_id.
We decided to remove the resolver table as it's not useful anymore. So we just simply did DROP TABLE resolver. However, we use 2ndQuadrant…
Natan
- 2,816
- 20
- 37
0
votes
1 answer
Is it possible to rebuild pg_depend?
I have a PostgreSQL 9.4 database affected by the following bug in BDR:
https://github.com/2ndQuadrant/bdr/issues/309
In a nutshell, that bug in BDR resulted in missing dependencies in the pg_depend system catalog. Now when I use pg_dump, objects…
csd
- 1,724
- 10
- 18