Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [repmgr]

Replication Manager for PostgreSQL clusters

Project page with documentation.

47 questions
14
votes
2 answers

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 not providing automatic failover for streaming…
Saurabh
  • 141
  • 1
  • 4
8
votes
2 answers

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 the slave's directories both in pg_xlogs and…
sqwale
  • 231
  • 1
  • 2
  • 6
7
votes
1 answer

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:…
wingedrhino
  • 578
  • 4
  • 12
4
votes
2 answers

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-ms47ox-10-3-105-192.vandelay.io standby |…
mjallday
  • 171
  • 1
  • 6
4
votes
1 answer

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 = 'test ! -f /mnt/share/psql/archive/psql/%f && cp %p…
Tombart
  • 1,160
  • 11
  • 23
3
votes
1 answer

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 -U repmgr -h [MASTERIP] -D…
Mackwerk
  • 189
  • 2
  • 8
3
votes
1 answer

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 psql01: [-bash-4.2$ repmgr -f…
Guif If
  • 131
  • 1
  • 2
3
votes
1 answer

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 features of PostgreSQL 9.1. Since we're using streaming…
River
  • 131
  • 5
3
votes
1 answer

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 and IP 192.168.1.243 using default port. I'd…
Rogerlr
  • 461
  • 4
  • 16
2
votes
0 answers

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 disconnects from the Upstream which causes a major…
David Petric
  • 21
  • 1
2
votes
1 answer

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 reconnect interval is 10…
Leonardo Lacerda
  • 324
  • 4
  • 14
2
votes
1 answer

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 pg_hba entries: The following is the query output…
CJ Chang
  • 295
  • 2
  • 4
  • 12
2
votes
0 answers

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 process shoulded happens automatically, but does not…
Alessandro Cardoso
  • 21
  • 4
2
votes
2 answers

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 I'd noticed that replication wasn't working…
Rogerlr
  • 461
  • 4
  • 16
2
votes
1 answer

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 verison of Application and OS is as mentioned…
yravi104
  • 21
  • 1
  • 3
1
2 3 4