BSD Portsdatabases/pg_auto_failover 2.2 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
- 937.7 KiB, 3397.0 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 17.
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
Install
Binary package:
pkg install postgresql17-pg_auto_failoverFrom the ports tree:
cd /usr/ports/databases/pg_auto_failover/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= postgresql17-pg_auto_failover>0:databases/pg_auto_failoverPackages
The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | 2.2 | 2.2 | - | - | 2.2 |
| FreeBSD:14:quarterly | 2.2 | 2.2 | n/a | - | 2.2 |
| FreeBSD:15:latest | 2.2 | 2.2 | n/a | - | - |
| FreeBSD:15:quarterly | 2.2 | 2.2 | n/a | n/a | n/a |
| FreeBSD:16:latest | 2.2 | 2.2 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/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
| File | Size | SHA256 |
|---|---|---|
| hapostgres-pg_auto_failover-v2.2_GH0.tar.gz | 1.140914e+06 | 0f4018564e620592fcfb43d52ea2bc3ccba33bd824352fa9c7e55eb2ba0a4f6c |