pg_auto_failover
pg_auto_failover copied to clipboard
Postgres extension and service for automated failover and high-availability
That way when the node shuts down, the group FSM has done the necessary steps already. If the node was a primary, another node has been elected to take over...
Both systemd and Kubernetes use a shutdown sequence that sends a SIGTERM signal then later a stronger one. See https://kubernetes.io/docs/concepts/workloads/pods/pod-lifecycle/#pod-termination for instance, where the default is to provide pods with...
Starting a monitor and running the following command 5 times in a row, causes the monitor to exit: ``` PG_AUTOCTL_DEBUG=true pg_autoctl do service restart listener --pgdata monitor ``` It exits...
This is a weird one. When using password auth, some entries in .pgpass make `pg_autoctl` to error when setting up replication, despite entries being valid and working fine with `pg_receivewal`...
(This shares similarities with #810, but I can't tell whether they have the same root cause.) We're seeing intermittent crashes when upgrading the monitor from 1.4.2 to 1.6.2: ``` TRAP:...
pg_auto_failover has a stand-alone Makefile that has an install target; it would be nice for users to also provide an uninstall target.
After #480, dropping a node at the same time that the primary is in the `join_primary` state results in a hung transition. Here's a sample state log: ``` 2020-10-29 17:15:52.809786+00:00...
Hi, I mainly want to check that I've a) followed the update procedure correctly and b) figure out how to proceed to get the cluster up again. On following the...
I had some issues with adding a new node and it seems that the data is registered in the pg_autofaiolver database. I failed to find where is located so I...
We are trying to use pg_auto_failover with Docker swarm. In Docker swarm the DNS reverse lookup of the container IP does not match its hostname, e.g. `db-monitor -> 192.168.1.10 ->...