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/

38 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
  • 367
  • 1
  • 5
  • 21
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
  • 463
  • 6
  • 8
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,847
  • 1
  • 27
  • 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
  • 69
  • 2
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,519
  • 2
  • 23
  • 42
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
  • 65
  • 1
  • 7
2
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
  • 446
  • 5
  • 22
2
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ź
  • 255
  • 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
  • 399
  • 3
  • 11
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
  • 7
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
  • 2,938
  • 3
  • 35
  • 59
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
  • 69
  • 5
1
vote
0 answers

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
  • 25
  • 6
1
vote
1 answer

Problem when upgrading postgres from 9.5 to 11

I have a problem using PostgreSQL when tried to upgrade it from 9.5 to 11. I'm using initdb to make my master and when I tried to pg_upgrade -c there is an error like this: Could not load library "$libdir/repmgr_funcs": ERROR: could not access…
Firman Susanto
  • 11
  • 4
1
vote
0 answers

Setup multiple Postgresql cluster IPs in kong pg_host

I am setting the kong as API gateway and using Postgres as datastore, I want to setup kong with pg cluster where if one Postgres instance down it can restart by using another one. Unable to provide multiple ips to pg_host in kong.conf pg_hba =…
Himanshu Gupta
  • 59
  • 1
  • 9
1
2 3