{"repo":"hapostgres/pg_auto_failover","free":true,"listed":false,"github":"https://github.com/hapostgres/pg_auto_failover","clone":"git clone https://github.com/hapostgres/pg_auto_failover.git","description":"Postgres extension and service for automated failover and high-availability","language":"C","stars":1376,"topics":["postgresql","postgres","postgresql-extension","high-availability","auto-failover"],"license":null,"category":"databases-storage","readme_excerpt":"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 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 Multiple Standbys It is possible to implement a production architecture with any number of Postgres nodes, for better data availability guarantees. By default, pg auto failover uses synchronous replication and every node that reaches the secondary state is added to synchronous standby names on the primary. With pg auto failover 1.4 it is possib","default_branch":null,"files":null,"tree":[],"storefront":"/r/hapostgres","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/hapostgres/pg_auto_failover/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}