Stack Overflow
Stack Overflow

Questions tagged [postgresql-bdr]

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

27 questions
1
vote
1 answer

Postgres BDR replication stopped - replication slot inactive

Our Postgres BDR database system stopped replicating data between the nodes. When I did a check using the pg_xlog_location_diff I noticed that there is a growing buffer in the replication slot. SELECT slot_name, database, active,…
postrational
  • 6,306
  • 3
  • 22
  • 27
1
vote
1 answer

Postgresql BDR Replication issue

I am trying to setup 2-node BDR replication and i am getting the following error while running bdr_init_copy. These are the steps: mkdir /postgres/pgsql-9.4/data /usr/pgsql-9.4/bin/pg_basebackup -h 10.10.145.111 -p 5432 -X stream -U postgres -D…
rkt
  • 11
  • 2
0
votes
1 answer

Rails' DelayedJob for a multi-master setup

I want to add one or two servers to my setup. I want it to be a multi-master setup with Postgresql-BDR to be available even if one server crashes. Now the problem: I use delayed_job pretty heavily. A job should only be run on one server to avoid…
Railsana
  • 1,813
  • 2
  • 21
  • 30
0
votes
1 answer

PostgreSQL BDR issues with replication slots

If I may, I would like to write a brief summary of the issue before I add more details to make my question cleaner and clearer: I have a BDR group running in production, replication works fine in all nodes, but I'm getting errors regarding a…
jbm-ayesa
  • 31
  • 1
  • 5
0
votes
1 answer

Postgres: increasing the bdr.max_databases variable fails

I'm currently encountering an issue regarding a BDR'd postgres database. Specifically, the maximum amount of databases allowed within a bdr cluster. According to the logs, I need to increase the value held by bdr.max_databases running postgres=#…
user100697
  • 1
  • 1
0
votes
1 answer

Couldn't install BDR-postgres on centos7

Followed all steps from the documetation untill the below command,where it got struck. sudo yum install postgresql-bdr94-bdr It returns error message saying "NO package postgresql-bdr94-bdr available"
Renjith JR
  • 189
  • 1
  • 3
  • 14
0
votes
0 answers

BDR Replication

I tried setting up the Multi master BDR for postgres, by following the steps provided in the quickstart. I Managed to get the installation and configuration correct(hopefully). I have two centos 7 servers: X and Y. Where postgres, bdr both were…
N.Sanj
  • 1
  • 4
0
votes
1 answer

Stop BDR from replicating DROP TABLE or CREATE TABLE

I have two databases with tables that I want to sync. I don't want to sync any other table. I'm using Postgres-BDR to do that. Those tables are part of replication set common. There are some circumstances where other tables share a name across nodes…
ABeard89
  • 911
  • 9
  • 17
0
votes
1 answer

PostgreSQL-BDR: Some of the nodes starts to replicate only after 2 hours after network problems

My setup is PostgreSQL-BDR on 4 servers with the same configuration. After network problems (e.g. connection lost for some minutes), some of the nodes start to replicate in some seconds again, but other nodes starts to replicate only after 2…
Robert Hegedus
  • 11
  • 4
0
votes
1 answer

Replication acknowledgement in PostgreSQL + BDR

I'm using libpq C Library for testing PG + BDR replica set. I'd like to get acknowledgement of the CRUD operations' replication. My purpose is to make my own log of the replication time in milliseconds or if possible in microseconds. The…
MagicDragon
  • 199
  • 1
  • 3
  • 18
0
votes
2 answers

I need to sort env.hosts to run tasks in a specific order

I need to sort the hosts from a roledef so they can run those tasks in a certain order. I'm implementing a PostgreSQL BDR (http://2ndquadrant.com/en-us/resources/bdr/) deployer. In order to succeed, you need to create a BDR group in a host and only…
otaviofcs
  • 785
  • 2
  • 6
  • 16
0
votes
0 answers

how to create a new column in postgresql UDR database

I need to be able to create a new column in an existing table in a database that has been set up to use postgresql UDR. From what I've read, you cannot run DDL commands in BDR unless you write the syntax in a specific way... For example, I found…
Happydevdays
  • 1,982
  • 5
  • 31
  • 57
1
2