Extensions
repmgr

repmgr

repmgr : Replication manager for PostgreSQL

Overview

ID Extension Package Version Category License Language
9710
repmgr
repmgr
 5.5.0
ETL
GPL-3.0
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--sLd--
No
Yes
Yes
Yes
no
no
Relationships
Schemas repmgr
See Also
pglogical
pg_failover_slots
pgactive
bgw_replstatus
postgres_fdw
pglogical_origin
pglogical_ticker
dblink

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 5.5.0
18
17
16
15
14
 repmgr -
RPM
PGDG
 5.5.0
18
17
16
15
14
 repmgr_$v -
DEB
PGDG
 5.5.0
18
17
16
15
14
 postgresql-$v-repmgr -
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
el8.aarch64
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
el9.x86_64
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
el9.aarch64
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
el10.x86_64
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
el10.aarch64
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
d12.x86_64
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
d12.aarch64
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
d13.x86_64
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
d13.aarch64
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
u22.x86_64
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
u22.aarch64
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
u24.x86_64
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
u24.aarch64
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
PGDG 5.5.0
Package Version OS ORG SIZE File URL
repmgr_18 5.5.0 el8.x86_64 pgdg 295.5 KiB repmgr_18-5.5.0-6PGDG.rhel8.10.x86_64.rpm
repmgr_18 5.5.0 el8.aarch64 pgdg 285.3 KiB repmgr_18-5.5.0-6PGDG.rhel8.10.aarch64.rpm
repmgr_18 5.5.0 el9.x86_64 pgdg 266.8 KiB repmgr_18-5.5.0-6PGDG.rhel9.7.x86_64.rpm
repmgr_18 5.5.0 el9.aarch64 pgdg 260.0 KiB repmgr_18-5.5.0-6PGDG.rhel9.7.aarch64.rpm
repmgr_18 5.5.0 el10.x86_64 pgdg 269.9 KiB repmgr_18-5.5.0-6PGDGrhel10.1.x86_64.rpm
repmgr_18 5.5.0 el10.aarch64 pgdg 261.0 KiB repmgr_18-5.5.0-6PGDGrhel10.1.aarch64.rpm
postgresql-18-repmgr 5.5.0 d12.x86_64 pgdg 246.7 KiB postgresql-18-repmgr_5.5.0+debpgdg-3.pgdg12+1_amd64.deb
postgresql-18-repmgr 5.5.0 d12.aarch64 pgdg 225.1 KiB postgresql-18-repmgr_5.5.0+debpgdg-3.pgdg12+1_arm64.deb
postgresql-18-repmgr 5.5.0 d13.x86_64 pgdg 246.2 KiB postgresql-18-repmgr_5.5.0+debpgdg-3.pgdg13+1_amd64.deb
postgresql-18-repmgr 5.5.0 d13.aarch64 pgdg 224.6 KiB postgresql-18-repmgr_5.5.0+debpgdg-3.pgdg13+1_arm64.deb
postgresql-18-repmgr 5.5.0 u22.x86_64 pgdg 235.2 KiB postgresql-18-repmgr_5.5.0+debpgdg-3.pgdg22.04+1_amd64.deb
postgresql-18-repmgr 5.5.0 u22.aarch64 pgdg 211.2 KiB postgresql-18-repmgr_5.5.0+debpgdg-3.pgdg22.04+1_arm64.deb
postgresql-18-repmgr 5.5.0 u24.x86_64 pgdg 231.3 KiB postgresql-18-repmgr_5.5.0+debpgdg-3.pgdg24.04+1_amd64.deb
postgresql-18-repmgr 5.5.0 u24.aarch64 pgdg 208.1 KiB postgresql-18-repmgr_5.5.0+debpgdg-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
repmgr_17 5.5.0 el8.x86_64 pgdg 295.1 KiB repmgr_17-5.5.0-1PGDG.rhel8.x86_64.rpm
repmgr_17 5.5.0 el8.aarch64 pgdg 285.2 KiB repmgr_17-5.5.0-1PGDG.rhel8.aarch64.rpm
repmgr_17 5.5.0 el9.x86_64 pgdg 267.9 KiB repmgr_17-5.5.0-1PGDG.rhel9.x86_64.rpm
repmgr_17 5.5.0 el9.aarch64 pgdg 261.0 KiB repmgr_17-5.5.0-1PGDG.rhel9.aarch64.rpm
repmgr_17 5.5.0 el10.x86_64 pgdg 270.4 KiB repmgr_17-5.5.0-3PGDG.rhel10.x86_64.rpm
repmgr_17 5.5.0 el10.aarch64 pgdg 261.6 KiB repmgr_17-5.5.0-3PGDG.rhel10.aarch64.rpm
postgresql-17-repmgr 5.5.0 d12.x86_64 pgdg 246.6 KiB postgresql-17-repmgr_5.5.0+debpgdg-3.pgdg12+1_amd64.deb
postgresql-17-repmgr 5.5.0 d12.aarch64 pgdg 225.5 KiB postgresql-17-repmgr_5.5.0+debpgdg-3.pgdg12+1_arm64.deb
postgresql-17-repmgr 5.5.0 d13.x86_64 pgdg 246.5 KiB postgresql-17-repmgr_5.5.0+debpgdg-3.pgdg13+1_amd64.deb
postgresql-17-repmgr 5.5.0 d13.aarch64 pgdg 224.6 KiB postgresql-17-repmgr_5.5.0+debpgdg-3.pgdg13+1_arm64.deb
postgresql-17-repmgr 5.5.0 u22.x86_64 pgdg 236.2 KiB postgresql-17-repmgr_5.5.0+debpgdg-3.pgdg22.04+1_amd64.deb
postgresql-17-repmgr 5.5.0 u22.aarch64 pgdg 212.0 KiB postgresql-17-repmgr_5.5.0+debpgdg-3.pgdg22.04+1_arm64.deb
postgresql-17-repmgr 5.5.0 u24.x86_64 pgdg 231.4 KiB postgresql-17-repmgr_5.5.0+debpgdg-3.pgdg24.04+1_amd64.deb
postgresql-17-repmgr 5.5.0 u24.aarch64 pgdg 207.5 KiB postgresql-17-repmgr_5.5.0+debpgdg-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
repmgr_16 5.5.0 el8.x86_64 pgdg 293.0 KiB repmgr_16-5.5.0-1PGDG.rhel8.x86_64.rpm
repmgr_16 5.4.1 el8.x86_64 pgdg 291.6 KiB repmgr_16-5.4.1-1PGDG.rhel8.x86_64.rpm
repmgr_16 5.5.0 el8.aarch64 pgdg 282.6 KiB repmgr_16-5.5.0-1PGDG.rhel8.aarch64.rpm
repmgr_16 5.4.1 el8.aarch64 pgdg 280.9 KiB repmgr_16-5.4.1-1PGDG.rhel8.aarch64.rpm
repmgr_16 5.5.0 el9.x86_64 pgdg 268.1 KiB repmgr_16-5.5.0-1PGDG.rhel9.x86_64.rpm
repmgr_16 5.4.1 el9.x86_64 pgdg 266.8 KiB repmgr_16-5.4.1-1PGDG.rhel9.x86_64.rpm
repmgr_16 5.5.0 el9.aarch64 pgdg 261.2 KiB repmgr_16-5.5.0-1PGDG.rhel9.aarch64.rpm
repmgr_16 5.4.1 el9.aarch64 pgdg 261.1 KiB repmgr_16-5.4.1-1PGDG.rhel9.aarch64.rpm
repmgr_16 5.5.0 el10.x86_64 pgdg 270.4 KiB repmgr_16-5.5.0-3PGDG.rhel10.x86_64.rpm
repmgr_16 5.5.0 el10.aarch64 pgdg 261.6 KiB repmgr_16-5.5.0-3PGDG.rhel10.aarch64.rpm
postgresql-16-repmgr 5.5.0 d12.x86_64 pgdg 244.8 KiB postgresql-16-repmgr_5.5.0+debpgdg-3.pgdg12+1_amd64.deb
postgresql-16-repmgr 5.5.0 d12.aarch64 pgdg 223.3 KiB postgresql-16-repmgr_5.5.0+debpgdg-3.pgdg12+1_arm64.deb
postgresql-16-repmgr 5.5.0 d13.x86_64 pgdg 244.5 KiB postgresql-16-repmgr_5.5.0+debpgdg-3.pgdg13+1_amd64.deb
postgresql-16-repmgr 5.5.0 d13.aarch64 pgdg 222.6 KiB postgresql-16-repmgr_5.5.0+debpgdg-3.pgdg13+1_arm64.deb
postgresql-16-repmgr 5.5.0 u22.x86_64 pgdg 233.7 KiB postgresql-16-repmgr_5.5.0+debpgdg-3.pgdg22.04+1_amd64.deb
postgresql-16-repmgr 5.5.0 u22.aarch64 pgdg 209.9 KiB postgresql-16-repmgr_5.5.0+debpgdg-3.pgdg22.04+1_arm64.deb
postgresql-16-repmgr 5.5.0 u24.x86_64 pgdg 229.5 KiB postgresql-16-repmgr_5.5.0+debpgdg-3.pgdg24.04+1_amd64.deb
postgresql-16-repmgr 5.5.0 u24.aarch64 pgdg 205.4 KiB postgresql-16-repmgr_5.5.0+debpgdg-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
repmgr_15 5.5.0 el8.x86_64 pgdg 291.7 KiB repmgr_15-5.5.0-1PGDG.rhel8.x86_64.rpm
repmgr_15 5.4.1 el8.x86_64 pgdg 290.4 KiB repmgr_15-5.4.1-1PGDG.rhel8.x86_64.rpm
repmgr_15 5.4.0 el8.x86_64 pgdg 289.9 KiB repmgr_15-5.4.0-1.rhel8.x86_64.rpm
repmgr_15 5.3.3 el8.x86_64 pgdg 286.4 KiB repmgr_15-5.3.3-1.rhel8.x86_64.rpm
repmgr_15 5.5.0 el8.aarch64 pgdg 282.3 KiB repmgr_15-5.5.0-1PGDG.rhel8.aarch64.rpm
repmgr_15 5.4.1 el8.aarch64 pgdg 280.8 KiB repmgr_15-5.4.1-1PGDG.rhel8.aarch64.rpm
repmgr_15 5.4.0 el8.aarch64 pgdg 280.4 KiB repmgr_15-5.4.0-1.rhel8.aarch64.rpm
repmgr_15 5.3.3 el8.aarch64 pgdg 276.5 KiB repmgr_15-5.3.3-1.rhel8.aarch64.rpm
repmgr_15 5.5.0 el9.x86_64 pgdg 270.1 KiB repmgr_15-5.5.0-1PGDG.rhel9.x86_64.rpm
repmgr_15 5.4.1 el9.x86_64 pgdg 268.7 KiB repmgr_15-5.4.1-1PGDG.rhel9.x86_64.rpm
repmgr_15 5.4.0 el9.x86_64 pgdg 268.6 KiB repmgr_15-5.4.0-1.rhel9.x86_64.rpm
repmgr_15 5.3.3 el9.x86_64 pgdg 266.8 KiB repmgr_15-5.3.3-1.rhel9.x86_64.rpm
repmgr_15 5.5.0 el9.aarch64 pgdg 263.0 KiB repmgr_15-5.5.0-1PGDG.rhel9.aarch64.rpm
repmgr_15 5.4.1 el9.aarch64 pgdg 263.0 KiB repmgr_15-5.4.1-1PGDG.rhel9.aarch64.rpm
repmgr_15 5.4.0 el9.aarch64 pgdg 262.8 KiB repmgr_15-5.4.0-1.rhel9.aarch64.rpm
repmgr_15 5.5.0 el10.x86_64 pgdg 270.8 KiB repmgr_15-5.5.0-3PGDG.rhel10.x86_64.rpm
repmgr_15 5.5.0 el10.aarch64 pgdg 262.3 KiB repmgr_15-5.5.0-3PGDG.rhel10.aarch64.rpm
postgresql-15-repmgr 5.5.0 d12.x86_64 pgdg 243.8 KiB postgresql-15-repmgr_5.5.0+debpgdg-3.pgdg12+1_amd64.deb
postgresql-15-repmgr 5.5.0 d12.aarch64 pgdg 222.1 KiB postgresql-15-repmgr_5.5.0+debpgdg-3.pgdg12+1_arm64.deb
postgresql-15-repmgr 5.5.0 d13.x86_64 pgdg 242.4 KiB postgresql-15-repmgr_5.5.0+debpgdg-3.pgdg13+1_amd64.deb
postgresql-15-repmgr 5.5.0 d13.aarch64 pgdg 221.9 KiB postgresql-15-repmgr_5.5.0+debpgdg-3.pgdg13+1_arm64.deb
postgresql-15-repmgr 5.5.0 u22.x86_64 pgdg 234.8 KiB postgresql-15-repmgr_5.5.0+debpgdg-3.pgdg22.04+1_amd64.deb
postgresql-15-repmgr 5.5.0 u22.aarch64 pgdg 211.2 KiB postgresql-15-repmgr_5.5.0+debpgdg-3.pgdg22.04+1_arm64.deb
postgresql-15-repmgr 5.5.0 u24.x86_64 pgdg 230.3 KiB postgresql-15-repmgr_5.5.0+debpgdg-3.pgdg24.04+1_amd64.deb
postgresql-15-repmgr 5.5.0 u24.aarch64 pgdg 206.1 KiB postgresql-15-repmgr_5.5.0+debpgdg-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
repmgr_14 5.5.0 el8.x86_64 pgdg 289.7 KiB repmgr_14-5.5.0-1PGDG.rhel8.x86_64.rpm
repmgr_14 5.4.1 el8.x86_64 pgdg 288.5 KiB repmgr_14-5.4.1-1PGDG.rhel8.x86_64.rpm
repmgr_14 5.4.0 el8.x86_64 pgdg 288.0 KiB repmgr_14-5.4.0-1.rhel8.x86_64.rpm
repmgr_14 5.3.3 el8.x86_64 pgdg 284.4 KiB repmgr_14-5.3.3-1.rhel8.x86_64.rpm
repmgr_14 5.3.2 el8.x86_64 pgdg 296.4 KiB repmgr_14-5.3.2-1.rhel8.x86_64.rpm
repmgr_14 5.3.1 el8.x86_64 pgdg 296.6 KiB repmgr_14-5.3.1-1.rhel8.x86_64.rpm
repmgr_14 5.3.0 el8.x86_64 pgdg 296.0 KiB repmgr_14-5.3.0-1.rhel8.x86_64.rpm
repmgr_14 5.5.0 el8.aarch64 pgdg 280.9 KiB repmgr_14-5.5.0-1PGDG.rhel8.aarch64.rpm
repmgr_14 5.4.1 el8.aarch64 pgdg 279.2 KiB repmgr_14-5.4.1-1PGDG.rhel8.aarch64.rpm
repmgr_14 5.4.0 el8.aarch64 pgdg 278.9 KiB repmgr_14-5.4.0-1.rhel8.aarch64.rpm
repmgr_14 5.3.3 el8.aarch64 pgdg 275.3 KiB repmgr_14-5.3.3-1.rhel8.aarch64.rpm
repmgr_14 5.5.0 el9.x86_64 pgdg 269.3 KiB repmgr_14-5.5.0-1PGDG.rhel9.x86_64.rpm
repmgr_14 5.4.1 el9.x86_64 pgdg 268.2 KiB repmgr_14-5.4.1-1PGDG.rhel9.x86_64.rpm
repmgr_14 5.4.0 el9.x86_64 pgdg 267.9 KiB repmgr_14-5.4.0-1.rhel9.x86_64.rpm
repmgr_14 5.3.3 el9.x86_64 pgdg 266.0 KiB repmgr_14-5.3.3-1.rhel9.x86_64.rpm
repmgr_14 5.3.2 el9.x86_64 pgdg 279.2 KiB repmgr_14-5.3.2-1.rhel9.x86_64.rpm
repmgr_14 5.3.1 el9.x86_64 pgdg 278.7 KiB repmgr_14-5.3.1-1.rhel9.x86_64.rpm
repmgr_14 5.5.0 el9.aarch64 pgdg 262.4 KiB repmgr_14-5.5.0-1PGDG.rhel9.aarch64.rpm
repmgr_14 5.4.1 el9.aarch64 pgdg 262.3 KiB repmgr_14-5.4.1-1PGDG.rhel9.aarch64.rpm
repmgr_14 5.4.0 el9.aarch64 pgdg 262.1 KiB repmgr_14-5.4.0-1.rhel9.aarch64.rpm
repmgr_14 5.5.0 el10.x86_64 pgdg 269.9 KiB repmgr_14-5.5.0-3PGDG.rhel10.x86_64.rpm
repmgr_14 5.5.0 el10.aarch64 pgdg 261.2 KiB repmgr_14-5.5.0-3PGDG.rhel10.aarch64.rpm
postgresql-14-repmgr 5.5.0 d12.x86_64 pgdg 243.0 KiB postgresql-14-repmgr_5.5.0+debpgdg-3.pgdg12+1_amd64.deb
postgresql-14-repmgr 5.5.0 d12.aarch64 pgdg 222.2 KiB postgresql-14-repmgr_5.5.0+debpgdg-3.pgdg12+1_arm64.deb
postgresql-14-repmgr 5.5.0 d13.x86_64 pgdg 241.6 KiB postgresql-14-repmgr_5.5.0+debpgdg-3.pgdg13+1_amd64.deb
postgresql-14-repmgr 5.5.0 d13.aarch64 pgdg 221.1 KiB postgresql-14-repmgr_5.5.0+debpgdg-3.pgdg13+1_arm64.deb
postgresql-14-repmgr 5.5.0 u22.x86_64 pgdg 233.3 KiB postgresql-14-repmgr_5.5.0+debpgdg-3.pgdg22.04+1_amd64.deb
postgresql-14-repmgr 5.5.0 u22.aarch64 pgdg 209.9 KiB postgresql-14-repmgr_5.5.0+debpgdg-3.pgdg22.04+1_arm64.deb
postgresql-14-repmgr 5.5.0 u24.x86_64 pgdg 229.6 KiB postgresql-14-repmgr_5.5.0+debpgdg-3.pgdg24.04+1_amd64.deb
postgresql-14-repmgr 5.5.0 u24.aarch64 pgdg 205.5 KiB postgresql-14-repmgr_5.5.0+debpgdg-3.pgdg24.04+1_arm64.deb

Source

Repository
github.com/EnterpriseDB/repmgr

Install

Make sure PGDG repo available:

pig repo add pgdg -u    # add pgdg repo and update cache

Install this extension with pig:

pig install repmgr;		# install via package name, for the active PG version

pig install repmgr -v 18;   # install for PG 18
pig install repmgr -v 17;   # install for PG 17
pig install repmgr -v 16;   # install for PG 16
pig install repmgr -v 15;   # install for PG 15
pig install repmgr -v 14;   # install for PG 14

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'repmgr';

Create this extension with:

CREATE EXTENSION repmgr;

Usage

repmgr: Replication manager for PostgreSQL

A suite of tools to manage replication and failover within a PostgreSQL cluster. Supports setting up standby servers, monitoring replication, and performing failover/switchover.

Enabling 

CREATE EXTENSION repmgr;

Configuration

Create repmgr.conf on each node:

node_id=1
node_name='node1'
conninfo='host=node1 dbname=repmgr user=repmgr'
data_directory='/var/lib/postgresql/data'

Register Primary 

repmgr -f /etc/repmgr.conf primary register

Clone and Register Standby 

# Clone from primary
repmgr -h primary-host -U repmgr -d repmgr -f /etc/repmgr.conf standby clone

# Start the standby
pg_ctl -D /var/lib/postgresql/data start

# Register the standby
repmgr -f /etc/repmgr.conf standby register

Monitoring 

# Show cluster status
repmgr -f /etc/repmgr.conf cluster show

# Show replication status
repmgr -f /etc/repmgr.conf node status

Manual Switchover

Promote a standby to primary (planned switchover):

repmgr -f /etc/repmgr.conf standby switchover

Automatic Failover with repmgrd

Start the repmgr daemon on each node:

repmgrd -f /etc/repmgr.conf

Configure failover in repmgr.conf:

failover='automatic'
promote_command='repmgr standby promote -f /etc/repmgr.conf'
follow_command='repmgr standby follow -f /etc/repmgr.conf --upstream-node-id=%n'

Key Commands

  • repmgr primary register - register a primary node
  • repmgr standby clone - clone a standby from primary
  • repmgr standby register - register a standby node
  • repmgr standby promote - promote standby to primary
  • repmgr standby follow - follow a new primary
  • repmgr standby switchover - planned switchover
  • repmgr cluster show - display cluster status
  • repmgr cluster event - show cluster events
  • repmgr node check - health check a node
Last updated on
mimeopg_fact_loader