Package pg_auto_failover

Postgres extension and service for automated failover and high-availability

https://github.com/citusdata/pg_auto_failover/

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 10 and newer.
We set up one PostgreSQL server as a monitor node as well as a primary and
secondary node for storing data. The monitor node tracks the health of the
data nodes and implements a failover state machine. On the PostgreSQL nodes,
the pg_autoctl program runs alongside PostgreSQL and runs the necessary
commands to configure synchronous streaming replication.

Version: 1.6.2

General Commands

pg_auto_failover pg_auto_failover Documentation
pg_autoctl The pg_autoctl tool is the client tool provided by pg_auto_failover to create and manage Postgres nodes and the pg_auto_failover monitor node.
pg_autoctl_config_check
pg_autoctl_config_get When the argument section.option is used, this is the name of a configuration ooption. The configuration file for pg_autoctl is stored using the INI format.
pg_autoctl_config_set This commands allows to set a pg_autoctl configuration setting to a new value. Most settings are possible to change and can be reloaded online.
pg_autoctl_create_formation A single pg_auto_failover monitor may manage any number of formations, each composed of at least one Postgres service group.
pg_autoctl_create_monitor The pg_autoctl tool is the client tool provided by pg_auto_failover to create and manage Postgres nodes and the pg_auto_failover monitor node.
pg_autoctl_create_postgres Three different modes of initialization are supported by this command, corresponding to as many implementation strategies.
pg_autoctl_disable_maintenance
pg_autoctl_disable_monitor
pg_autoctl_disable_secondary
pg_autoctl_disable_ssl
pg_autoctl_drop_formation
pg_autoctl_drop_monitor
pg_autoctl_drop_node Two modes of operations are implemented in the pg_autoctl drop node command.
pg_autoctl_enable_maintenance
pg_autoctl_enable_monitor
pg_autoctl_enable_secondary
pg_autoctl_enable_ssl
pg_autoctl_get_formation_number-sync-standbys See also pg_autoctl_show_settings for the full list of replication settings.
pg_autoctl_get_formation_settings See also pg_autoctl_show_settings which is a synonym.
pg_autoctl_get_node_candidate-priority See also pg_autoctl_show_settings for the full list of replication settings.
pg_autoctl_get_node_replication-quorum See also pg_autoctl_show_settings for the full list of replication settings.
pg_autoctl_perform_failover The pg_auto_failover monitor can be used to orchestrate a manual failover, sometimes also known as a switchover.
pg_autoctl_perform_promotion The pg_auto_promotion monitor can be used to orchestrate a manual promotion, sometimes also known as a switchover.
pg_autoctl_perform_switchover The pg_auto_switchover monitor can be used to orchestrate a manual switchover, sometimes also known as a switchover.
pg_autoctl_reload
pg_autoctl_run
pg_autoctl_set_formation_number-sync-standbys The pg_auto_failover monitor ensures that at least N+1 candidate standby nodes are registered when number-sync-standbys is N.
pg_autoctl_set_node_candidate-priority See also pg_autoctl_show_settings for the full list of replication settings.
pg_autoctl_set_node_replication-quorum See also pg_autoctl_show_settings for the full list of replication settings.
pg_autoctl_show_events
pg_autoctl_show_file
pg_autoctl_show_settings See also pg_autoctl_get_formation_settings which is a synonym.
pg_autoctl_show_standby-names
pg_autoctl_show_state
pg_autoctl_show_uri
pg_autoctl_status
pg_autoctl_stop

File Formats

pg_autoctl