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 2026-03-14

mimeo pg_fact_loader