Questions tagged [repmgr]

Replication Manager for PostgreSQL clusters

Filter by
Sorted by
Tagged with
0 votes
0 answers
15 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 ...
user avatar
  • 1
0 votes
1 answer
61 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 ...
user avatar
1 vote
0 answers
18 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 ...
user avatar
0 votes
0 answers
35 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? ...
user avatar
1 vote
1 answer
44 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 ...
user avatar
  • 1,331
0 votes
0 answers
20 views

repmgr standby unregister

PostgreSQL version 10.16 Repmgr version 4.4 After issued repmgr standby unregister on the standby node, the database still receiving replicated data from the primary server. I queried the repmgr.nodes ...
user avatar
  • 157
0 votes
0 answers
15 views

Postgres Repmgr

I tried implementing Repmgr for auto failover solution on postgres.No w the proble I face is once I say stop the service of the primary it gets failover and when I bring up the earlier secondary it is ...
user avatar
0 votes
0 answers
174 views

Postgres major upgrade with repmgr

I have a three node cluster pg_version 10, i'm trying to upgrade it to pg_version 11. Also, that cluster is managed by repmgr 10, which should also be upgraded to version 11. I have followed after ...
user avatar
2 votes
0 answers
52 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 ...
user avatar
1 vote
1 answer
101 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 | ...
user avatar
  • 13
1 vote
1 answer
157 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 ...
user avatar
0 votes
1 answer
307 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 ...
user avatar
0 votes
1 answer
94 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) ...
user avatar
  • 149
0 votes
1 answer
51 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'...
user avatar
  • 149
1 vote
1 answer
110 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. ...
user avatar
  • 236
0 votes
0 answers
26 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/...
user avatar
  • 149
0 votes
2 answers
180 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 ...
user avatar
  • 149
0 votes
0 answers
354 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 ...
user avatar
  • 236
1 vote
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 ...
user avatar
  • 111
0 votes
1 answer
2k 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 ...
user avatar
  • 149
-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 ...
user avatar
  • 133
1 vote
1 answer
35 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... ...
user avatar
  • 157
1 vote
0 answers
184 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 ...
user avatar
0 votes
1 answer
90 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!
user avatar
  • 157
0 votes
1 answer
431 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 | ...
user avatar
  • 157
2 votes
1 answer
947 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 ...
user avatar
  • 157
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 ...
user avatar
  • 105
1 vote
0 answers
411 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 ...
user avatar
1 vote
1 answer
123 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 ...
user avatar
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 ...
user avatar
3 votes
1 answer
572 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 ...
user avatar
  • 401
0 votes
2 answers
4k 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 ...
user avatar
  • 401
0 votes
0 answers
152 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) ...
user avatar
  • 83
0 votes
0 answers
288 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 ...
user avatar
  • 1,698
1 vote
3 answers
775 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 ...
user avatar
  • 852
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 = '...
user avatar
  • 852
1 vote
0 answers
636 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 ...
user avatar
  • 11
4 votes
2 answers
14k 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 ...
user avatar
  • 181
2 votes
1 answer
2k 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 ...
user avatar
0 votes
1 answer
803 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 ...
user avatar
  • 181
1 vote
1 answer
373 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 ...
user avatar
  • 852
3 votes
2 answers
6k 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-...
user avatar
  • 161
1 vote
1 answer
425 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 ...
user avatar
  • 121
0 votes
1 answer
891 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 ...
user avatar
  • 145
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 ...
user avatar
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 -...
user avatar
  • 179
3 votes
1 answer
546 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 ...
user avatar
  • 131
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-...
user avatar
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 ...
user avatar
  • 141