Extensions
pgautofailover

pgautofailover

pgautofailover : pg_auto_failover

Overview

ID Extension Package Version Category License Language
5150
pgautofailover
pgautofailover
 2.2
ADMIN
PostgreSQL
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--sLd--
No
Yes
Yes
Yes
no
no
Relationships
Requires
btree_gist
See Also
pglogical
pglogical_origin
pg_failover_slots
pgpool_recovery
repmgr
pg_checksums
pgpool_adm
bgw_replstatus

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 2.2
18
17
16
15
14
13
 pgautofailover -
RPM
PGDG
 2.2
18
17
16
15
14
13
 pg_auto_failover_$v* -
DEB
PGDG
 2.2
18
17
16
15
14
13
 postgresql-$v-auto-failover -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
el8.aarch64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
el9.x86_64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
el9.aarch64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
el10.x86_64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
el10.aarch64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
d12.x86_64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
d12.aarch64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
d13.x86_64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
d13.aarch64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
u22.x86_64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
u22.aarch64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
u24.x86_64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
u24.aarch64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
Package Version OS ORG SIZE File URL
pg_auto_failover_17 2.2 el8.x86_64 pgdg 812.9 KiB pg_auto_failover_17-2.2-1PGDG.rhel8.x86_64.rpm
pg_auto_failover_17 2.2 el8.aarch64 pgdg 809.9 KiB pg_auto_failover_17-2.2-1PGDG.rhel8.aarch64.rpm
pg_auto_failover_17 2.2 el9.x86_64 pgdg 786.3 KiB pg_auto_failover_17-2.2-1PGDG.rhel9.x86_64.rpm
pg_auto_failover_17 2.2 el9.aarch64 pgdg 789.2 KiB pg_auto_failover_17-2.2-1PGDG.rhel9.aarch64.rpm
pg_auto_failover_17 2.2 el10.x86_64 pgdg 788.0 KiB pg_auto_failover_17-2.2-1PGDG.rhel10.x86_64.rpm
pg_auto_failover_17 2.2 el10.aarch64 pgdg 785.7 KiB pg_auto_failover_17-2.2-1PGDG.rhel10.aarch64.rpm
postgresql-17-auto-failover 2.2 d12.x86_64 pgdg 372.6 KiB postgresql-17-auto-failover_2.2-2.pgdg120+1_amd64.deb
postgresql-17-auto-failover 2.2 d12.aarch64 pgdg 370.0 KiB postgresql-17-auto-failover_2.2-2.pgdg120+1_arm64.deb
postgresql-17-auto-failover 2.2 d13.x86_64 pgdg 374.0 KiB postgresql-17-auto-failover_2.2-2.pgdg130+1_amd64.deb
postgresql-17-auto-failover 2.2 d13.aarch64 pgdg 371.0 KiB postgresql-17-auto-failover_2.2-2.pgdg130+1_arm64.deb
postgresql-17-auto-failover 2.2 u22.x86_64 pgdg 393.4 KiB postgresql-17-auto-failover_2.2-2.pgdg22.04+1_amd64.deb
postgresql-17-auto-failover 2.2 u22.aarch64 pgdg 389.1 KiB postgresql-17-auto-failover_2.2-2.pgdg22.04+1_arm64.deb
postgresql-17-auto-failover 2.2 u24.x86_64 pgdg 363.8 KiB postgresql-17-auto-failover_2.2-2.pgdg24.04+1_amd64.deb
postgresql-17-auto-failover 2.2 u24.aarch64 pgdg 360.2 KiB postgresql-17-auto-failover_2.2-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_auto_failover_16 2.2 el8.x86_64 pgdg 812.5 KiB pg_auto_failover_16-2.2-1PGDG.rhel8.x86_64.rpm
pg_auto_failover_16 2.1 el8.x86_64 pgdg 844.0 KiB pg_auto_failover_16-2.1-1PGDG.rhel8.x86_64.rpm
pg_auto_failover_16 2.2 el8.aarch64 pgdg 809.4 KiB pg_auto_failover_16-2.2-1PGDG.rhel8.aarch64.rpm
pg_auto_failover_16 2.1 el8.aarch64 pgdg 843.8 KiB pg_auto_failover_16-2.1-1PGDG.rhel8.aarch64.rpm
pg_auto_failover_16 2.2 el9.x86_64 pgdg 786.3 KiB pg_auto_failover_16-2.2-1PGDG.rhel9.x86_64.rpm
pg_auto_failover_16 2.1 el9.x86_64 pgdg 807.5 KiB pg_auto_failover_16-2.1-1PGDG.rhel9.x86_64.rpm
pg_auto_failover_16 2.2 el9.aarch64 pgdg 789.1 KiB pg_auto_failover_16-2.2-1PGDG.rhel9.aarch64.rpm
pg_auto_failover_16 2.1 el9.aarch64 pgdg 817.4 KiB pg_auto_failover_16-2.1-1PGDG.rhel9.aarch64.rpm
pg_auto_failover_16 2.2 el10.x86_64 pgdg 788.1 KiB pg_auto_failover_16-2.2-1PGDG.rhel10.x86_64.rpm
pg_auto_failover_16 2.2 el10.aarch64 pgdg 785.7 KiB pg_auto_failover_16-2.2-1PGDG.rhel10.aarch64.rpm
postgresql-16-auto-failover 2.2 d12.x86_64 pgdg 368.4 KiB postgresql-16-auto-failover_2.2-2.pgdg120+1_amd64.deb
postgresql-16-auto-failover 2.2 d12.aarch64 pgdg 364.9 KiB postgresql-16-auto-failover_2.2-2.pgdg120+1_arm64.deb
postgresql-16-auto-failover 2.2 d13.x86_64 pgdg 369.9 KiB postgresql-16-auto-failover_2.2-2.pgdg130+1_amd64.deb
postgresql-16-auto-failover 2.2 d13.aarch64 pgdg 364.8 KiB postgresql-16-auto-failover_2.2-2.pgdg130+1_arm64.deb
postgresql-16-auto-failover 2.2 u22.x86_64 pgdg 386.8 KiB postgresql-16-auto-failover_2.2-2.pgdg22.04+1_amd64.deb
postgresql-16-auto-failover 2.2 u22.aarch64 pgdg 383.4 KiB postgresql-16-auto-failover_2.2-2.pgdg22.04+1_arm64.deb
postgresql-16-auto-failover 2.2 u24.x86_64 pgdg 359.8 KiB postgresql-16-auto-failover_2.2-2.pgdg24.04+1_amd64.deb
postgresql-16-auto-failover 2.2 u24.aarch64 pgdg 354.9 KiB postgresql-16-auto-failover_2.2-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_auto_failover_15 2.2 el8.x86_64 pgdg 812.6 KiB pg_auto_failover_15-2.2-1PGDG.rhel8.x86_64.rpm
pg_auto_failover_15 2.1 el8.x86_64 pgdg 843.6 KiB pg_auto_failover_15-2.1-1PGDG.rhel8.x86_64.rpm
pg_auto_failover_15 2.0 el8.x86_64 pgdg 842.5 KiB pg_auto_failover_15-2.0-1.rhel8.x86_64.rpm
pg_auto_failover_15 2.2 el8.aarch64 pgdg 809.3 KiB pg_auto_failover_15-2.2-1PGDG.rhel8.aarch64.rpm
pg_auto_failover_15 2.1 el8.aarch64 pgdg 843.0 KiB pg_auto_failover_15-2.1-1PGDG.rhel8.aarch64.rpm
pg_auto_failover_15 2.0 el8.aarch64 pgdg 841.6 KiB pg_auto_failover_15-2.0-1.rhel8.aarch64.rpm
pg_auto_failover_15 2.2 el9.x86_64 pgdg 789.5 KiB pg_auto_failover_15-2.2-1PGDG.rhel9.x86_64.rpm
pg_auto_failover_15 2.1 el9.x86_64 pgdg 811.6 KiB pg_auto_failover_15-2.1-1PGDG.rhel9.x86_64.rpm
pg_auto_failover_15 2.0 el9.x86_64 pgdg 812.1 KiB pg_auto_failover_15-2.0-1.rhel9.x86_64.rpm
pg_auto_failover_15 2.2 el9.aarch64 pgdg 792.9 KiB pg_auto_failover_15-2.2-1PGDG.rhel9.aarch64.rpm
pg_auto_failover_15 2.1 el9.aarch64 pgdg 820.9 KiB pg_auto_failover_15-2.1-1PGDG.rhel9.aarch64.rpm
pg_auto_failover_15 2.0 el9.aarch64 pgdg 821.5 KiB pg_auto_failover_15-2.0-1.rhel9.aarch64.rpm
pg_auto_failover_15 2.2 el10.x86_64 pgdg 791.7 KiB pg_auto_failover_15-2.2-1PGDG.rhel10.x86_64.rpm
pg_auto_failover_15 2.2 el10.aarch64 pgdg 788.8 KiB pg_auto_failover_15-2.2-1PGDG.rhel10.aarch64.rpm
postgresql-15-auto-failover 2.2 d12.x86_64 pgdg 367.8 KiB postgresql-15-auto-failover_2.2-2.pgdg120+1_amd64.deb
postgresql-15-auto-failover 2.2 d12.aarch64 pgdg 364.3 KiB postgresql-15-auto-failover_2.2-2.pgdg120+1_arm64.deb
postgresql-15-auto-failover 2.2 d13.x86_64 pgdg 369.5 KiB postgresql-15-auto-failover_2.2-2.pgdg130+1_amd64.deb
postgresql-15-auto-failover 2.2 d13.aarch64 pgdg 366.2 KiB postgresql-15-auto-failover_2.2-2.pgdg130+1_arm64.deb
postgresql-15-auto-failover 2.2 u22.x86_64 pgdg 390.5 KiB postgresql-15-auto-failover_2.2-2.pgdg22.04+1_amd64.deb
postgresql-15-auto-failover 2.2 u22.aarch64 pgdg 387.0 KiB postgresql-15-auto-failover_2.2-2.pgdg22.04+1_arm64.deb
postgresql-15-auto-failover 2.2 u24.x86_64 pgdg 359.7 KiB postgresql-15-auto-failover_2.2-2.pgdg24.04+1_amd64.deb
postgresql-15-auto-failover 2.2 u24.aarch64 pgdg 356.6 KiB postgresql-15-auto-failover_2.2-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_auto_failover_14 2.2 el8.x86_64 pgdg 810.9 KiB pg_auto_failover_14-2.2-1PGDG.rhel8.x86_64.rpm
pg_auto_failover_14 2.1 el8.x86_64 pgdg 841.9 KiB pg_auto_failover_14-2.1-1PGDG.rhel8.x86_64.rpm
pg_auto_failover_14 2.0 el8.x86_64 pgdg 840.6 KiB pg_auto_failover_14-2.0-1.rhel8.x86_64.rpm
pg_auto_failover_14 1.6.4 el8.x86_64 pgdg 994.9 KiB pg_auto_failover_14-1.6.4-1.rhel8.x86_64.rpm
pg_auto_failover_14 1.6.2 el8.x86_64 pgdg 929.2 KiB pg_auto_failover_14-1.6.2-1.rhel8.x86_64.rpm
pg_auto_failover_14 2.2 el8.aarch64 pgdg 808.0 KiB pg_auto_failover_14-2.2-1PGDG.rhel8.aarch64.rpm
pg_auto_failover_14 2.1 el8.aarch64 pgdg 841.4 KiB pg_auto_failover_14-2.1-1PGDG.rhel8.aarch64.rpm
pg_auto_failover_14 2.0 el8.aarch64 pgdg 840.1 KiB pg_auto_failover_14-2.0-1.rhel8.aarch64.rpm
pg_auto_failover_14 2.2 el9.x86_64 pgdg 789.0 KiB pg_auto_failover_14-2.2-1PGDG.rhel9.x86_64.rpm
pg_auto_failover_14 2.1 el9.x86_64 pgdg 811.2 KiB pg_auto_failover_14-2.1-1PGDG.rhel9.x86_64.rpm
pg_auto_failover_14 2.0 el9.x86_64 pgdg 811.7 KiB pg_auto_failover_14-2.0-1.rhel9.x86_64.rpm
pg_auto_failover_14 1.6.4 el9.x86_64 pgdg 966.2 KiB pg_auto_failover_14-1.6.4-1.rhel9.x86_64.rpm
pg_auto_failover_14 2.2 el9.aarch64 pgdg 792.5 KiB pg_auto_failover_14-2.2-1PGDG.rhel9.aarch64.rpm
pg_auto_failover_14 2.1 el9.aarch64 pgdg 820.6 KiB pg_auto_failover_14-2.1-1PGDG.rhel9.aarch64.rpm
pg_auto_failover_14 2.0 el9.aarch64 pgdg 821.0 KiB pg_auto_failover_14-2.0-1.rhel9.aarch64.rpm
pg_auto_failover_14 2.2 el10.x86_64 pgdg 792.2 KiB pg_auto_failover_14-2.2-1PGDG.rhel10.x86_64.rpm
pg_auto_failover_14 2.2 el10.aarch64 pgdg 789.6 KiB pg_auto_failover_14-2.2-1PGDG.rhel10.aarch64.rpm
postgresql-14-auto-failover 2.2 d12.x86_64 pgdg 362.7 KiB postgresql-14-auto-failover_2.2-2.pgdg120+1_amd64.deb
postgresql-14-auto-failover 2.2 d12.aarch64 pgdg 358.7 KiB postgresql-14-auto-failover_2.2-2.pgdg120+1_arm64.deb
postgresql-14-auto-failover 2.2 d13.x86_64 pgdg 364.1 KiB postgresql-14-auto-failover_2.2-2.pgdg130+1_amd64.deb
postgresql-14-auto-failover 2.2 d13.aarch64 pgdg 360.2 KiB postgresql-14-auto-failover_2.2-2.pgdg130+1_arm64.deb
postgresql-14-auto-failover 2.2 u22.x86_64 pgdg 384.9 KiB postgresql-14-auto-failover_2.2-2.pgdg22.04+1_amd64.deb
postgresql-14-auto-failover 2.2 u22.aarch64 pgdg 381.4 KiB postgresql-14-auto-failover_2.2-2.pgdg22.04+1_arm64.deb
postgresql-14-auto-failover 2.2 u24.x86_64 pgdg 354.8 KiB postgresql-14-auto-failover_2.2-2.pgdg24.04+1_amd64.deb
postgresql-14-auto-failover 2.2 u24.aarch64 pgdg 351.0 KiB postgresql-14-auto-failover_2.2-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_auto_failover_13 2.2 el8.x86_64 pgdg 810.5 KiB pg_auto_failover_13-2.2-1PGDG.rhel8.x86_64.rpm
pg_auto_failover_13 2.1 el8.x86_64 pgdg 840.6 KiB pg_auto_failover_13-2.1-1PGDG.rhel8.x86_64.rpm
pg_auto_failover_13 2.0 el8.x86_64 pgdg 839.5 KiB pg_auto_failover_13-2.0-1.rhel8.x86_64.rpm
pg_auto_failover_13 1.6.4 el8.x86_64 pgdg 993.7 KiB pg_auto_failover_13-1.6.4-1.rhel8.x86_64.rpm
pg_auto_failover_13 1.6.2 el8.x86_64 pgdg 927.9 KiB pg_auto_failover_13-1.6.2-1.rhel8.x86_64.rpm
pg_auto_failover_13 1.6.1 el8.x86_64 pgdg 1.2 MiB pg_auto_failover_13-1.6.1-1.rhel8.x86_64.rpm
pg_auto_failover_13 1.6.1 el8.x86_64 pgdg 924.8 KiB pg_auto_failover_13-1.6.1-2.rhel8.x86_64.rpm
pg_auto_failover_13 1.5.2 el8.x86_64 pgdg 1.2 MiB pg_auto_failover_13-1.5.2-1.rhel8.x86_64.rpm
pg_auto_failover_13 1.5.1 el8.x86_64 pgdg 1.3 MiB pg_auto_failover_13-1.5.1-1.rhel8.x86_64.rpm
pg_auto_failover_13 1.4.1 el8.x86_64 pgdg 1.3 MiB pg_auto_failover_13-1.4.1-1.rhel8.x86_64.rpm
pg_auto_failover_13 1.4.0 el8.x86_64 pgdg 1.3 MiB pg_auto_failover_13-1.4.0-1.rhel8.x86_64.rpm
pg_auto_failover_13 2.2 el8.aarch64 pgdg 807.9 KiB pg_auto_failover_13-2.2-1PGDG.rhel8.aarch64.rpm
pg_auto_failover_13 2.1 el8.aarch64 pgdg 841.4 KiB pg_auto_failover_13-2.1-1PGDG.rhel8.aarch64.rpm
pg_auto_failover_13 2.0 el8.aarch64 pgdg 840.1 KiB pg_auto_failover_13-2.0-1.rhel8.aarch64.rpm
pg_auto_failover_13 2.2 el9.x86_64 pgdg 789.4 KiB pg_auto_failover_13-2.2-1PGDG.rhel9.x86_64.rpm
pg_auto_failover_13 2.1 el9.x86_64 pgdg 811.7 KiB pg_auto_failover_13-2.1-1PGDG.rhel9.x86_64.rpm
pg_auto_failover_13 2.0 el9.x86_64 pgdg 812.0 KiB pg_auto_failover_13-2.0-1.rhel9.x86_64.rpm
pg_auto_failover_13 1.6.4 el9.x86_64 pgdg 966.8 KiB pg_auto_failover_13-1.6.4-1.rhel9.x86_64.rpm
pg_auto_failover_13 2.2 el9.aarch64 pgdg 792.8 KiB pg_auto_failover_13-2.2-1PGDG.rhel9.aarch64.rpm
pg_auto_failover_13 2.1 el9.aarch64 pgdg 820.6 KiB pg_auto_failover_13-2.1-1PGDG.rhel9.aarch64.rpm
pg_auto_failover_13 2.0 el9.aarch64 pgdg 821.3 KiB pg_auto_failover_13-2.0-1.rhel9.aarch64.rpm
pg_auto_failover_13 2.2 el10.x86_64 pgdg 792.4 KiB pg_auto_failover_13-2.2-1PGDG.rhel10.x86_64.rpm
pg_auto_failover_13 2.2 el10.aarch64 pgdg 790.1 KiB pg_auto_failover_13-2.2-1PGDG.rhel10.aarch64.rpm
postgresql-13-auto-failover 2.2 d12.x86_64 pgdg 359.0 KiB postgresql-13-auto-failover_2.2-2.pgdg120+1_amd64.deb
postgresql-13-auto-failover 2.2 d12.aarch64 pgdg 354.8 KiB postgresql-13-auto-failover_2.2-2.pgdg120+1_arm64.deb
postgresql-13-auto-failover 2.2 d13.x86_64 pgdg 360.3 KiB postgresql-13-auto-failover_2.2-2.pgdg130+1_amd64.deb
postgresql-13-auto-failover 2.2 d13.aarch64 pgdg 356.1 KiB postgresql-13-auto-failover_2.2-2.pgdg130+1_arm64.deb
postgresql-13-auto-failover 2.2 u22.x86_64 pgdg 382.7 KiB postgresql-13-auto-failover_2.2-2.pgdg22.04+1_amd64.deb
postgresql-13-auto-failover 2.2 u22.aarch64 pgdg 377.9 KiB postgresql-13-auto-failover_2.2-2.pgdg22.04+1_arm64.deb
postgresql-13-auto-failover 2.2 u24.x86_64 pgdg 351.1 KiB postgresql-13-auto-failover_2.2-2.pgdg24.04+1_amd64.deb
postgresql-13-auto-failover 2.2 u24.aarch64 pgdg 347.3 KiB postgresql-13-auto-failover_2.2-2.pgdg24.04+1_arm64.deb

Source

Repository
github.com/hapostgres/pg_auto_failover

Install

Make sure PGDG repo available:

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

Install this extension with pig:

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

pig install pgautofailover -v 17;   # install for PG 17
pig install pgautofailover -v 16;   # install for PG 16
pig install pgautofailover -v 15;   # install for PG 15
pig install pgautofailover -v 14;   # install for PG 14
pig install pgautofailover -v 13;   # install for PG 13

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'pgautofailover';

Create this extension with:

CREATE EXTENSION pgautofailover CASCADE; -- requires btree_gist
Last updated on
pg_permissionspg_catcheck