governor
governor copied to clipboard
compose
Runners to orchestrate a high-availability PostgreSQL
We're using the hostnames of the PostgreSQL Servers as replication slot names. A new name schema introduced dashes in the hostnames. This leads to fails. There is an unused function...
primary_conninfo = 'user=**None** password=None host=**None** port=None sslmode=prefer sslcompression=1' the connect info has "None" After I have debug the function write_recovery_conf of postgresql.py: { leader = urlparse(leader_hash["address"]) f.write(""" primary_conninfo = 'user=%(user)s...
In order to enable Kubernetes services which communicate with the PostgreSQL master, I need to update some annotations in the Kubernetes API. As such, I want to execute a script...
maximum_lag_on_failover incorrectly tries to query an existing leader for the WAL position. Problem is, the time which maximum_lag_on_failover should be checked - a leader wouldn't exist. Solution would be to...
Currently - if an underlying PG process is misbehaving and the pg service interface issues a command to `pg_ctl` to fix it and that command has a non-zero exit status...
Hi, we just started to use governor and it seems to be more or less working. However I saw in the log files these exceptions: Traceback (most recent call last):...
``` if self.has_lock(): self.update_lock() ``` this is not atomic, and update_lock would fail if too slow (412), could combine them together
Hello, I'm no pg expert, but I'm a bit surprised you don't try to rewind an ex-leader trying to rejoin the cluster. That's why pg 9.5 introduced the pg_rewind command....
I have setup a postgresql cluster (with one master node and one slave/standby node) using Governor. I want to use HA proxy in front of my cluster. I think in...
This adds support for etcd as a cluster, plus nice syntax. I'm also getting a problem with current library reading members list, so I'll go for a refactor and sibmit...
