Questions tagged [repmgr]

Replication Manager for PostgreSQL clusters

13 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
337 views

Repmgr: Error to promote Standby Cluster to Master Cluster in failover

I maked the configuration of the failover system based in Repmgr, but i don't haved success to promote the Standby Cluster to Master Cluster in case of failover. Following my configurations, this ...
2
votes
1answer
959 views

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 II and Repmgr. I have followed the link to do the setup. The setup consist of 3 nodes and ...
1
vote
0answers
162 views

PGpool not properly detecting which postgres server is master

I am in the process of building a resilient database cluster and currently have 3 database servers running postgres 10 and repmgr. repmgr is taking care of the streaming replication including ...
1
vote
1answer
47 views

Replication with Repmgr + native streaming replication

I have an environment where the old DBA used the repmgr. And now I need to add a second replica to use as a "dump server". But my question is regarding using the native mode of PostgreSQL via stream ...
1
vote
1answer
377 views

pg_repack slows down PostgreSQL replication

I have a master PostgreSQL 9.5 server and a standby server. For replication I use repmgr (WAL streaming). Typically the delay between master and standby is <5s: $ psql -t -c "SELECT extract(epoch ...
1
vote
0answers
403 views

PostgreSQL: Removing standby from streaming replication

I have PostgreSQL 9.4 streaming replication setup between three nodes (master and two hot standbys). I use repmgr to control the replication cluster. I need to retire one of the standbys and remove it ...
0
votes
0answers
18 views

pg_dump does not return schema for repmgr objects

While trying to browse repmgr.monitoring_history, I noticed it has many tens of millions of records. Wanting to get a peak at the indexes that (may or may not) already exist on the table, I try a ...
0
votes
1answer
21 views

PostgreSQL cluster has two primary databases after network glitch

My test environment had network glitch over the weekend and I ended up having two Primary databases up and running in the cluster. ID | Name | Role | Status | ...
0
votes
1answer
74 views

pg_hba error while setting up repmgr

Please help me to figure it out, help is much appreciated! ERROR: FATAL: no pg_hba.conf entry for replication connection from host "172.18.0.4", user "repmgr", SSL on The following is a list of my ...
0
votes
1answer
192 views

Postgresql Replica is in sync but repmgr says node unattached

I've set up a replica of a Postgresql instance using repmgr, and the replica is totally in sync with the master instance and have been in sync since some days, but repmgr tells me replica isn't ...
0
votes
0answers
73 views

rh-postgresql96(Red Hat provided postgresql) vs postgresql-9.6 (community postgresql)

Our client has provided us Red Hat machine for setting up PostgreSQL. We are allowed to install red hat provided packages only. So we have to install red hat provided postgresql (rh-postgresql96) ...
0
votes
0answers
202 views

Postgresql - Is this possible to setup a Zero downtime PostgreSQL Cluster?

I have already asked here about PostgreSQL HA setup, and I got many possible answers. But the bad thing is, even though if I use any third party software like PGpool, Repmgr, pacemaker are asking for ...
0
votes
1answer
22 views

How to install repmgr 4.2 (ubuntu)

apt-get install postgresql-10-repmgr give me repmgr 4.3. However, my primary server is still on 4.2. How do I install repmgr version 4.2? Thanks in advance!