Stack Overflow
Stack Overflow

Questions tagged [repmgr]

repmgr is a set of open source tools that helps DBAs and System administrators manage a cluster of PostgreSQL databases.

repmgr is a set of open source tools that helps DBAs and System administrators manage a cluster of PostgreSQL databases.

By taking advantage of the Hot Standby capability introduced in PostgreSQL 9, repmgr greatly simplifies the process of setting up and managing database with high availability and scalability requirements.

repmgr simplifies administration and daily management, enhances productivity and reduces the overall costs of a PostgreSQL cluster by:

  • monitoring the replication process;
  • allowing DBAs to issue high availability operations such as switch-overs and fail-overs.

Home: http://repmgr.org/

49 questions
1
vote
1 answer

Problem when upgrading postgres from 9.5 to 11

I have a problem using PostgreSQL when tried to upgrade it from 9.5 to 11. I'm using initdb to make my master and when I tried to pg_upgrade -c there is an error like this: Could not load library "$libdir/repmgr_funcs": ERROR: could not access…
Firman Susanto
  • 13
  • 5
1
vote
0 answers

Setup multiple Postgresql cluster IPs in kong pg_host

I am setting the kong as API gateway and using Postgres as datastore, I want to setup kong with pg cluster where if one Postgres instance down it can restart by using another one. Unable to provide multiple ips to pg_host in kong.conf pg_hba =…
Himanshu Gupta
  • 69
  • 1
  • 10
1
vote
1 answer

pgpool HA + repmgr for Postgresql 9.6

I'm trying to conifure pgpool in my postgresql environment (2 postgresql servers + 1 pgpool) to do HA while repmgr is responsible for the replication. I'm getting the next messages in the log : 017-12-03 19:27:07: pid 19033: DEBUG: pool_flush_it:…
JeyJ
  • 3,582
  • 4
  • 35
  • 83
1
vote
1 answer

How to failback with Postgresql cluster using repmgr?

I want to build a Postgresql Cluster in a Cloud environment (yes I know it's a bad idea ... but that is not the question). For your information, I use a Dockerized Postgresql (see: https://github.com/paunin/postgres-docker-cluster) but that is not…
jmcollin92
  • 2,896
  • 6
  • 27
  • 49
1
vote
1 answer

Automatic recovery of the failed postgresql master node is not working with pgpool II

I am new to Postgresql and Pgpool II setup. I have configured the Postgresql HA/Load balancing using Pgpool and Repmgr. The setup consist of 3 nodes and verison of Application and OS is as mentioned below: **Pgpool node** => 192.168.0.4,…
yravi104
  • 23
  • 1
  • 3
1
vote
2 answers

[Postgres Replication]Remote host is not reachable repmgr salve

I am trying to create a postgres replication configuration using two servers. The steps are similar to PostgreSQL 9.4 Replication with RepMgr and PgBouncer on Ubuntu 14.04 . I am using repmgr + pgbouncer as my replication configuration. Say I have…
Mohammed Aadil
  • 153
  • 7
1
vote
1 answer

Auto FailOver not working in repmgr

I had successfully setup the two nodes (Master & Satndby). My version is repmgr 2.0 (PostgreSQL 9.3.6) standby repmgr.conf cluster=test node=2 node_name=node2 conninfo='host=192.168.1.218 user=repmgr_usr…
Rajiv
  • 582
  • 2
  • 8
  • 18
1
vote
1 answer

repmgr Error: A master must be defined before configuring a slave

I am using the repmgr for replication. I had registered the Master node to repmgr successfully. I had successfully cloned the Master node & Started the Standby server. But the Problem is I cannot register the Standby node in repmgr. I am using the…
Rajiv
  • 582
  • 2
  • 8
  • 18
1
vote
1 answer

Master slave delay(activate synchronous commit) and pg_xlog in a separate disk

We are preparing to add repmgr to an existant Postgresql 9.3 two nodes streaming replication cluster. Previously we had a serious problem that affected our main business, the problem was the delay between master and slave, which we resolved by…
adilnaimi
  • 209
  • 2
  • 4
0
votes
0 answers

postgresql-ha "unable to connect to upstream node" randomly, causing pgpool "kind does not match between main(0) slot[0] (52)"

Environment: kubernetes with istio sidecars injected. I'm using bitnami/postgresql-ha as a database for my airflow, and randomly seeing the below log in my postgresql statefulset with 3 pods (image: bitnami/postgresql-repmgr:15.3.0-debian-11-r8).…
Jasmine H
  • 1
  • 1
0
votes
0 answers

Why can't repmgr attach my replica to the master?

I have a cluster of some posgtgresql databases and a Barman server for backup, managed with Repmgr. I'm currently in the process of attaching a new replica. The replica is currently cloning from Barman and now I would like to attach it to the master…
Niels Kristian
  • 8,661
  • 11
  • 59
  • 117
0
votes
2 answers

error: connection to server at "10.0.30.7", port 5432 failed: No route to host

at first, I want a HA PostgreSQL by repmgr subnet its 10.0.30.0/24 da1 server 10.0.30.7 -- master da2 server 10.0.30.6 -- worker so i get error postgres@da2:~$ repmgr -h 10.0.30.7 -U repmgr -d repmgr -f repmgr.conf standby clone --dry-run NOTICE:…
eman Feah
  • 23
  • 3
0
votes
0 answers

Issue with repmgr's reported version during PostgreSQL 12 switchover

PostgreSQL12 problem when switchover with repmgr 5.3.2. Hello everyone, I have a problem when perform swithover with repmgr. I have 2 servers, primary and standby. When running the following command: /usr/pgsql-12/bin/repmgr standby swithover -f…
Dara Saang
  • 1
0
votes
1 answer

repmgr pg_rewind failed with could not fetch pg_control remote file

I'm testing repmgr to setup auto fail over and replication for postgreSQL cluster. So far I had reach the stage where I had successfully setup a 3-nodes cluster which consists of one primary and 2 standby. Fail over is a success in which I purposely…
Xonos
  • 103
  • 10
0
votes
1 answer

Postgres Register Standby fails

I am trying to setup a Primary and a standby using repmgr. I think I have successfully setup master, but standby setup keeps failing. On Standby node /usr/pgsql-12/bin/repmgr -h master_ip standby clone NOTICE: destination directory…
Oxycash
  • 167
  • 12
1
2
3 4