BSD Ports

databases/pg_auto_failover-devel g20251117 FreeBSD

Postgres extension for automated failover and high-availability

System
FreeBSD
Repository
FreeBSD ports
Maintainer
[email protected]
Last update
Commit
79c3aeb472
License
PostgreSQL
Categories
databases
Package size
939.9 KiB, 3401.8 KiB installed

Description

pg_auto_failover is an extension and service for PostgreSQL that monitors and manages automated failover for a Postgres cluster. It is optimized for simplicity and correctness and supports Postgres 13 to 18.

pg_auto_failover supports several Postgres architectures and implements a safe automated failover for your Postgres service. It is possible to get started with only two data nodes which will be given the roles of primary and secondary by the monitor.

The pg_auto_failover Monitor implements a state machine and relies on in-core PostgreSQL facilities to deliver HA. For example, when the secondary node is detected to be unavailable, or when its lag is too much, then the Monitor removes it from the synchronous_standby_names setting on the primary node. Until the secondary is back to being monitored healthy, failover and switchover operations are not allowed, preventing data loss.

pg_auto_failover consists of the following parts:

  • a PostgreSQL extension named pgautofailover
  • a PostgreSQL service to operate the pg_auto_failover monitor
  • a pg_auto_failover keeper to operate your PostgreSQL instances, see pg_autoctl run

This is the development version tracking the main branch.

Install

Binary package:

pkg install postgresql18-pg_auto_failover-devel

From the ports tree:

cd /usr/ports/databases/pg_auto_failover-devel/ && make install clean

To depend on this port in another port's Makefile:

RUN_DEPENDS=	postgresql18-pg_auto_failover-devel>0:databases/pg_auto_failover-devel

Packages

The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.

Repositoryaarch64amd64armv6armv7i386
FreeBSD:14:latestg20251117g20251117--g20251117
FreeBSD:14:quarterlyg20251117g20251117n/a-g20251117
FreeBSD:15:latestg20251117g20251117n/a--
FreeBSD:15:quarterlyg20251117g20251117n/an/an/a
FreeBSD:16:latestg20251117g20251117n/an/an/a
FreeBSD:16:quarterlyn/an/an/an/an/a

Dependencies

The Makefile names none itself; they come from USES and USE_*.

The full lists below include those, and their dependencies in turn.

Build dependencies 12
Run dependencies 11

No port depends on this one.

Configuration

No options to configure.

USES
gmake pgsql:14-${__MAX_PGSQL}
Service scripts
pg_auto_failover
Conflicts with
postgresql*-pg_auto_failover*

Files

pkg-plist 15
  • bin/pg_autoctl
  • lib/postgresql/pgautofailover.so
  • share/postgresql/extension/pgautofailover--1.0--1.1.sql
  • share/postgresql/extension/pgautofailover--1.0.sql
  • share/postgresql/extension/pgautofailover--1.1--1.2.sql
  • share/postgresql/extension/pgautofailover--1.2--1.3.sql
  • share/postgresql/extension/pgautofailover--1.3--1.4.sql
  • share/postgresql/extension/pgautofailover--1.4--1.5.sql
  • share/postgresql/extension/pgautofailover--1.5--1.6.sql
  • share/postgresql/extension/pgautofailover--1.6--2.0.sql
  • share/postgresql/extension/pgautofailover--2.0--2.1.sql
  • share/postgresql/extension/pgautofailover--2.1--2.2.sql
  • share/postgresql/extension/pgautofailover--2.2--dummy.sql
  • share/postgresql/extension/pgautofailover--2.2.sql
  • share/postgresql/extension/pgautofailover.control
distinfo 1
FileSizeSHA256
hapostgres-pg_auto_failover-g20251117-5f31d4f5ef322b339d67cfd79d773e11f9e30fb0_GH0.tar.gz1.142071e+06d9aef136094c1f90ca39221155b95df04d7e209662b1a715740bfbe14cac5221

Commit history 1

DateCommitCreditsLog message
79c3aeb472 Pat Maddox Update patmaddox maintainer email
Approved by: dch (mentor implicit) Closes: https://github.com/freebsd/freebsd-ports/pull/566