pg_auto_failover
pg_auto_failover copied to clipboard
Postgres extension and service for automated failover and high-availability
We're testing out the newly added support in pg_auto_failover for a Citus formation. In our Citus formation, we use `pg_dist_poolinfo` alongside `pg_dist_node` so that the internal connections between Citus nodes...
Moving from postgres 13 to 15 i bumped into an issue using `target_session_attrs=read-write`, where `default_transaction_read_only` would be `off` on standbys, resulting in clients connecting to the standby. I have worked...
Is it possible specify pgwal directory? I could not find any config about that.
This allows users of pg_auto_failover to setup their own scripts/actions to complement a failover. The hooks are run in a process that is separate from the main FSM, so as...
-bash-4.2$ pg_autoctl create postgres --hostname 192.168.2.116 --auth trust --no-ssl --monitor 'postgres://[email protected]:5432/pg_auto_failover?sslmode=prefer' 14:32:15 1541 WARN No encryption is used for network traffic! This allows an attacker on the network to read...
The state of node_2 under .local/share/pg_autoctl/u01/pgdata/13/data/pg_autoctl.state is removed accidentally. Hence, the postgresql of node_2 cannot be started after running "sudo systemctl restart pgautofailover", is there any way to fix let...
I have followed the installation instructions on Ubuntu 18 and Ubuntu 20. Ubuntu 18 only seems to install version 1.6 while Ubuntu 20 installs version 2. Is Ubuntu 20, the...
Since `pg_autoctl show state` no longer populated the "Reachable" field (it always shows unknown), we should use the supported "health" field instead.
Addresses the following warnings: - FromAsCasing - LegacyKeyValueFormat - JSONArgsRecommended
Hello, first thanks a lot for this opensource project. We use pg_autofailover for more than a year and half with this kind of setup: 1 monitor and 3 nodes num...