Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [repmgr]

Replication Manager for PostgreSQL clusters

14
votes
2answers
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 ...
6
votes
1answer
5k 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-...
4
votes
1answer
975 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 = '...
3
votes
1answer
4k 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-...
3
votes
1answer
498 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 ...
3
votes
1answer
190 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 ...
3
votes
1answer
2k 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 -...
2
votes
1answer
3k 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 ...
2
votes
1answer
238 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
840 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
1answer
301 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 ...
1
vote
1answer
339 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 ...
1
vote
0answers
128 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
42 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
342 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
360 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
2answers
489 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 ...
0
votes
1answer
714 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 ...
0
votes
1answer
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 ...
0
votes
1answer
14 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
40 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
0answers
130 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
211 views

PostgreSQL, repmgr & pgbouncer: Configuration questions

I have a PostgreSQL v9.6 cluster installed on a Linux server (Scientific Linux release 6.9), with repmgr to handle failovers. I have a master & two standby servers that all have PostgreSQL v9.6 ...
0
votes
0answers
68 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
192 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
625 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 ...