Stack Overflow
Stack Overflow

Questions tagged [repmgr]

repmgr is a set of open source tools that helps DBAs and System administrators manage a cluster of PostgreSQL databases.

repmgr is a set of open source tools that helps DBAs and System administrators manage a cluster of PostgreSQL databases.

By taking advantage of the Hot Standby capability introduced in PostgreSQL 9, repmgr greatly simplifies the process of setting up and managing database with high availability and scalability requirements.

repmgr simplifies administration and daily management, enhances productivity and reduces the overall costs of a PostgreSQL cluster by:

  • monitoring the replication process;
  • allowing DBAs to issue high availability operations such as switch-overs and fail-overs.

Home: http://repmgr.org/

49 questions
5
votes
1 answer

ERROR could not access file "$libdir/repmgr_funcs" No such file or directory

I follow this link to create master slave replication on Ubuntu postgresql server. My Configuration of repmgr and postgresql are: Postgresql 9.5-: /opt/PostgreSQL/9.5/ repmgr-: /usr/lib/postgresql/9.5/bin/repmgr repmgr.conf -:…
Manish Yadav
  • 435
  • 2
  • 8
  • 24
5
votes
1 answer

What is the purpose of `pg_logical` directory inside PostgreSQL data?

I've just stumbled upon this error while testing failover of a PostgreSQL 9.4 cluster I've set up. Here I'm trying to promote a slave to be the new master: $ repmgr -f /etc/repmgr/repmgr.conf --verbose standby promote 2014-09-22 10:46:37 UTC LOG: …
vlprans
  • 473
  • 6
  • 8
4
votes
1 answer

How to use repmgr with dockerized Postgresql?

I'm trying to create Postgresql setup with replication and automatic failover. I wanted it to be reusable, scalable and portable, so I tried to use docker to run Postgres. I also didnt want to reinvent the wheel, so I tried to use repmgr as it is…
Patryk Wlaź
  • 493
  • 5
  • 11
3
votes
1 answer

repmgrd and supervisord on docker - losing parent?

I've created a Docker image with PostgreSQL and repmgrd, all launched with supervisor. My problem now is that when it's launched, the repmgrd spawned by supervisor seems to kind of die and another one is in its place. This leads to my inability to…
Stephan
  • 1,858
  • 2
  • 25
  • 46
3
votes
0 answers

PostgreSQL/PostDock: Auto recovery failed in master node

I use Docker service and Docker swarm to deploy the PostDock cluster This is my docker-compose.yml setup: version: "3.3" networks: postdock: external: true services: pgmaster: image: postdock/postgres environment: …
moeman
  • 119
  • 4
3
votes
2 answers

PgPool-II and repmgr Automatic Failover

I have pgpool-II for HA and repmgr for automatic failover. Pgpool-II also can also run failover I am just wondering doing automatic failover using pgpool or repmgr? If pgpool can do the failover do I need to use repmgr? and use shell scripts to the…
varun7447
  • 574
  • 1
  • 6
  • 27
2
votes
0 answers

repmgr - recover from failed primary?

Hi all using repmgr to test some failover logic Unsure what command is needed to recover from this situation: repmgr -f /etc/repmgr.conf cluster show ID | Name | Role | Status | Upstream | Location | Priority | Timeline |…
IanWatson
  • 1,649
  • 2
  • 27
  • 49
2
votes
1 answer

Assigning virtual IP in repmgr

I have a postgres cluster made using repmgr. This is the requirement of the application that they should not have to change the IP in the application when the database switchover occurs. Is there a way to use virtual IP with repmgr which outside…
makhshif afiniti
  • 55
  • 1
  • 8
2
votes
0 answers

repmgr - Automate process of making primary to standby after failover

I have two postgres servers running on CentOS 7 with repmgr 4.1.0-1. So far I have automated the process of promoting the standby to primary after the primary server fails but when it comes back they both act as primary and I don't think the…
ejfilip
  • 75
  • 2
  • 10
2
votes
1 answer

Clustering PostgreSQL clusters

This will be confusing for some due to poor terminology choices by the PostgreSQL folks, but please bear with me... We have a need to be able to support multiple PostgreSQL (PG) clusters, and cluster them on multiple servers using, e.g. repmgr. For…
MushyMiddle
  • 419
  • 6
  • 14
2
votes
1 answer

Unable to demote DB with repmgr

I am using repmgr and had successfully failed over to a standby node. However when I attempeted to recover the failed master node, I now find that I have two master nodes. I have tried to re register the standby node as standby. But I find that…
pvawser
  • 98
  • 1
  • 7
1
vote
0 answers

Error: (repmgr) server is in standby mode and cannot be registered as a primary

I tried to follow this link: https://repmgr.org/docs/current/repmgr-primary-register.html and run this command: repmgr primary register --force --dry-run
Mr.FreshPR
  • 11
  • 2
1
vote
0 answers

Do you need watchdog on pgpool when using repmgr?

I'm using docker swarm and was hoping to use these containers https://github.com/bitnami/bitnami-docker-pgpool and https://github.com/bitnami/bitnami-docker-postgresql-repmgr. For postgres, I'm going to configure 3 different services and repmgr…
FatalCatharsis
  • 3,407
  • 5
  • 44
  • 74
1
vote
1 answer

repmgr standby switchover failed with ERROR: unable to connect via SSH to host "node IP", user ""

repmgr standby switchover -v INFO: looking for configuration file in /etc INFO: configuration file found at: "/etc/repmgr.conf" NOTICE: executing switchover on node "DB-Test-02" (ID: 2) WARNING: unable to connect to remote host "IP" via SSH ERROR:…
Darshan Shah
  • 157
  • 1
  • 1
  • 15
1
vote
1 answer

repmgr - how to make previous Primary to become a standby after failover

After performing a fail over, I had the previous Primary down, and the old standby became the Primary, as expected. $ repmgr -f /etc/repmgr.conf cluster show --compact ID | Name | Role | Status | Upstream | Location | Prio. |…
Tamar
  • 145
  • 4
  • 15
1
2 3 4