Questions tagged [repmgr]
Replication Manager for PostgreSQL clusters
47
questions
14
votes
2
answers
5k
views
Streaming replication and failover on PostgreSQL
I am doing a proof of concept on PostgreSQL replication. After the discussion on forum we decided to go with streaming replication as the performance is good compared to other solutions. PostgreSQL is ...
- 141
7
votes
1
answer
6k
views
PostgreSQL: Unable to run repmgr cloned database
I'm running tests with PostgreSQL hot standby with 1 master, and exactly 1 slave.
I am using the instructions on this guide: http://www.howtoforge.com/how-to-set-up-a-postgresql-9.0-hot-standby-...
- 568
7
votes
2
answers
20k
views
Postgres requested WAL segment has already been removed (however it is actually in the slave's directory)
I am using repmgr as my replication tool. On the slave I keep getting an error:
requested WAL segment has already been removed
When I check the Master indeed it is not there; however, it is in ...
- 211
4
votes
1
answer
2k
views
How to restore PostgreSQL standby server from archive?
I have a PostgreSQL 9.5 cluster with master and standby server that are replicated using repmgr. Master is configured to keep 4000 WAL files:
wal_level = logical
hot_standby = on
archive_command = '...
- 962
3
votes
2
answers
7k
views
Removing a FAILED node from repmgr cluster
How do I remove failed node from a PostgreSQL cluster?
postgres@db-prod-ms47ox-10-3-104-92:~$ repmgr -f /etc/repmgr/repmgr.conf cluster show
Role | Connection String
* master | host=db-prod-...
- 161
3
votes
1
answer
556
views
Witnessing standby failure with repmgr
We're setting up a PostgreSQL cluster, and we're looking at using repmgr to handle standby promotion and so on.
Our cluster has one master and a hot standby, and uses the streaming replication ...
- 131
3
votes
1
answer
631
views
Trying to replicate 2 or more Postgres instances to one standby host
My setup has 2 Postgres hosts:
host SRV1 as primary with 2 instances and IP 192.168.1.241
Instance A listening on port 5432
Instance B listening on port 5433
host SRV2 as standby with instance C ...
- 421
3
votes
1
answer
3k
views
Can't set up witness in Repmgr 2.0
I am trying to setup repmgr using the autofailover quick setup tutorial provided on Github Link
But I am kind of stuck on the witness section, when trying to create the witness with repmgr -d repmgr -...
- 179
2
votes
1
answer
2k
views
Is it possible that the old primary follow the new secondary?
I need to change the roles between two nodes.
Circumstance:
2servers:
primary: psql01 and
standby: psql02
After psql01 stops, psql02 becomes the new primary. After a while, start psql01
On ...
- 121
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
2
answers
5k
views
Postgres repmgr - downstream nodes not attached
I'd configured repmgr replication on node1 and node3 (primary and standby respectively), and the setup worked sucessfully creating new records and objects on standby as expected.
But after some weeks ...
- 421
1
vote
3
answers
1k
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 ...
- 962
1
vote
1
answer
48
views
Many PG Clusters on more than one machine
I want to run ~10k PostgreSQL clusters.
Each cluster will be quite small with moderate traffic.
I have will have roughly 100 virtual machines. Each VM should run roughly 100 clusters. Each cluster ...
- 1,371
1
vote
1
answer
218
views
What does the repmgr the symbol "*" mean in the repmgr cluster status output?
I'm new to postgres administration and was wondering what does the "*" symbol means in the repmgr cluster show command output.
ID | Name | Role | Status | Upstream | Location | ...
- 13
1
vote
1
answer
319
views
REPMGR - change reconnect_attempts and reconnect_interval not working
I configured PostgreSQL automatic failover with REPMGR. But, in my simulation the sleeping time is 1 second for each reconnect attempt:
If I consult official documentation the default value to ...
- 304
1
vote
1
answer
239
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 ...
- 4,448
1
vote
1
answer
206
views
how long can your replica be offline when using repmgr with Barman?
I'm setting up some postgres database EC2 instances that I'd like to use for load balancing. The application I'm running has some very expensive and very unique queries so CPU usage is a concern. ...
- 236
1
vote
1
answer
49
views
repmgr 4.4 upgrade
I did apt-get install repmgr and tried to upgrade repmgr from 4.3 to 4.4
root@node-01:~# apt-get install repmgr
Reading package lists... Done
Building dependency tree
Reading state information... ...
- 165
1
vote
1
answer
426
views
postgresql: PANIC: cannot operate with inconsistent data
I'm trying to setup a replica using repmgr:
repmgr -D /var/lib/postgresql/9.3/main -p 5432 -U repmgr -R postgres \
--verbose standby clone psql.master.example.com
repmgr --verbose standby register
...
- 962
1
vote
1
answer
515
views
Connection pooling with 3 databases but 1 database as master for repmgr replication?
I'm using pgbouncer for connection pooling against 3 database on different servers, now I'm planning to use repmgr for replication, my question is, can I keep doing connection pooling on these 3 ...
- 121
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
724
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
319
views
Is it possible to make a high availability PostgreSQL database cluster by open source softwares?
If use these tools can make a great modern database cluster with full features:
pgbouncer (with HAProxy for HA)
repmgr
barman
The main database will run on the repmgr servers. It has primary and ...
- 269
0
votes
1
answer
957
views
repmgr: Can I replicate databases from two different masters to a third slave?
If I have a master node 1 (with database A) and a master node 2 (with database B) can I use repmgr and have both A and B replicated to a hot standby node 3 ?
[ EDIT: They would all be running ...
- 145
0
votes
1
answer
114
views
HA 3-Node Postgres cluster on VMs with Repmgr
We are considering a 3-node Postgres setup where 1-master and 2-standby with replication and master failover handled by repmgr and connection pooling with Pgbouncer.
Is there a way to let our ...
- 1
0
votes
1
answer
129
views
Why use synchronous_standby_names = 'barman_receive_wal' will cause database aberrant?
Use barman's synchronous_standby_names feature in PostgreSQL's postgresql.conf file
synchronous_standby_names = 'barman_receive_wal'
Can't do these operations:
createuser(hanging)
createdb(hanging)
...
- 269
0
votes
1
answer
83
views
How to use repmgr with PostgreSQL 10?
Followed the official repmgr document, I set these items to the configuration file:
shared_preload_libraries = 'repmgr'
max_wal_senders = 10
max_replication_slots = 10
wal_level = 'hot_standby'...
- 269
0
votes
1
answer
1k
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 ...
- 105
0
votes
1
answer
1k
views
Taking hot backup of slave node in postgres (master-slave config with repmgr)
I have a postgresql setup with master-slave configuration using repmgr. I'm struggling with taking a consistent snapshot backup (pg_start_backup) of the slave node, this is due the fact that the slave ...
- 101
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
278
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
3k
views
How to do automatic failover for PostgreSQL with application automatic switch?
There are two ways to try.
Method 1
Use JDBC connect the PostgreSQL cluster (primary, standby 2 servers only):
jdbc:postgresql://192.168.0.1:5432,192.168.0.2:5432/jiradb
But failed:
The ...
- 269
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
876
views
repmgr 3.0.4 and postgres 9.4 on ubuntu (ERROR: replication slot "repmgr_slot_2" does not exist)
I'm not a DBA but I have been tasked with setting up a database and streaming replication and repmgr is the tool I have decided to use.
The master goes on fine and I can see it registered in the ...
- 211
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