Postgres extension and service for automated failover and high-availability
https://github.com/hapostgres/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: 2.1
General Commands | |
| pg_auto_failover | |
| 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_activate | When creating a Citus worker, pg_autoctl create worker automatically activates the worker node to the coordinator. |
| 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_coordinator | |
| 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_create_worker | |
| 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 | |
| pg_autoctl_watch | The pg_autoctl watch output is divided in 3 sections. |
File Formats | |
| pg_autoctl | |