Questions tagged [repmgr]
Replication Manager for PostgreSQL clusters
19
questions with no upvoted or accepted answers
2
votes
0
answers
128
views
PostgreSQL Replication disconnects after deleting DB
I've got a PostgreSQL Replication set up using Repmgr.
Replication works fine, until one of the databases is deleted on the master node.
Standby replica throws off 'WAL cannot be found' error and ...
- 21
2
votes
1
answer
1k
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
1
answer
3k
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 ...
- 21
2
votes
1
answer
1k
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 ...
- 165
1
vote
0
answers
471
views
Pgpool for HA of Postgres with repmgr switchover. Pgpool haw to follow primary
I'm trying to setup a highly available postgres (13) cluster(3 servers) with streaming replication.
I first tried native replication and then decided to use repmgr to manage this so I could use the ...
- 11
1
vote
0
answers
107
views
How to activate barman_slot in PostgreSQL?
I am using PostgreSQL cluster with Barman backup tools. I just recovered one of my backups. After recover, I found barman slot is inactive. Later, I deleted that inactive barman slot and created ...
1
vote
0
answers
512
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 ...
- 111
1
vote
1
answer
135
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
0
answers
723
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 ...
- 11
0
votes
2
answers
84
views
in PostgreSQL REPMGR Master-Slave environment is it necessary to have same H/W config for HOT STANDBY setup?
I have a PostgreSQL repmgr Master-Slave setup with HOT standby enabled. In such repmgr configuration isnt it possible to configure the postgresql.conf in Primary and secondary DIFFERENTLY WHILE HOT ...
0
votes
1
answer
745
views
Is wal_keep_segments required with streaming replication when archive and restore commands are set?
I have a 2 node postresql(12.9) cluster with streaming replication enabled. I have also set the archive and restore commands which I verified is working as expected. No replication slots or ...
- 1
0
votes
1
answer
277
views
How to reload repmgr configuration changes?
I use repmgr to provide failover to my PostgreSQL cluster.
If I change a server-specific parameter in the repmgr.conf file for one of my standbys, how do I get repmgr to recognize the changed value? ...
- 21
0
votes
1
answer
455
views
Repmgr : It automatically promotes to new master but other standby stopped
I'm trying to setup postgre with repmgr and here is the rsult
The scenario is,
i tried to spinup 1 primary and 2 standby.
then i stop the primary so the postgres-2 got promoted.
Unfortunately the ...
0
votes
0
answers
125
views
Why repmgr didn't failover automatically?
Installation
- name: Install repmgr repository
get_url:
url: https://dl.2ndquadrant.com/default/release/get/10/rpm
dest: /var/lib/pgsql/repmgr
- name: Install repmgr rpm
shell: bash /var/...
- 269
0
votes
0
answers
478
views
install postgresql without creating instance (for use with repmgr)
I'm trying to get REPMGR setup, and I'm following the steps at https://repmgr.org/docs/current/quickstart-standby-preparation.html to get the standby setup.
I noticed it warns On the standby, do not ...
- 236
0
votes
1
answer
595
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 | ...
- 165
0
votes
0
answers
207
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) ...
- 83
0
votes
1
answer
106
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!
- 165
-1
votes
1
answer
1k
views
repmgr on PostgreSQL 10 failed, recovering
I'm running a 3 nodes PostgreSQL 10 + repmgr 4.4 cluster:
1 master node (postgres1.domain.local)
2 stabdby nodes (postgres2.domain.local and postgres2.domain.local)
The cluster was running fine ...
- 143