pg_auto_failover

pg_auto_failover copied to clipboard

group_id conflicts with keyword

1

Hi, hackers, I'm a database(postgresql variant) developer and we're considering to port pg_auto_failover for our database. The `group_id` is defined to be a keyword for a long time, which conflicts...

gfphoenix78

React correctly to change in replication.password

5

Addresses #382 . Followed the steps outlined in https://github.com/citusdata/pg_auto_failover/issues/382#issuecomment-683686687

soumyadeep2007

Optionaly redirect logs to stdout ?

1

Hi, In a container/kubernetes environment, it's a good practice to log only to stdout / stderr. The logs are then easily collected and aggregated. it looks like pg_autoctl is redirecting...

trecloux

Setting replication.password doesn't set the password in the primary's database instance

6

## Description Following the steps in the documentation [here](https://github.com/citusdata/pg_auto_failover/blob/7ac18c5d0a07fb23738032bd74e5b8896a48cd81/docs/security.rst#authentication-with-passwords) to setup password based authentication is not enough without an added: `psql -p ${PRIMARY_PORT} postgres -c "alter user pgautofailover_replicator password 'h4ckm3m0r3';`...

soumyadeep2007

This way we should find timing issues in our code sooner. An example of this was #245.

JelteF

Upgrade primary and standby via pg_autoctl

3

It would be useful if `pg_autoctl` had a command to upgrade the primary and standby to a new version of Postgres via `pg_upgrade` without triggering a failover.

marcocitus

Cannot Use it with Oracle Linux

3

Hi, I tried install pg_auto_failover on Oracle Linux 8, but it says Oracle Linux is not supported. As Oracle Linux is a rpm based distribution, very similar to CentOS/Red Hat,...

mfcosta

Check result code of sformat

2

Although we are using `snprintf` to make sure we don't overflow a buffer, we don't actually check if the whole string was written in most cases. If this would occur,...

JelteF

I have seen following error regarding use of _Static_assert that we recently introduced. ``` make -C pg_autoctl pg_autoctl make[2]: Entering directory `/root/pg_auto_failover/src/bin/pg_autoctl' gcc -std=c99 -D_GNU_SOURCE -g -I /usr/pgsql-10/include -I /usr/pgsql-10/include/server...

mtuncer

I adjusted the pg_autoctl.cfg (monitor) [postgresql] ... listen_addresses = localhost,postgres-ha When I reboot postgres listens to localhost (despite the Log-Entry shows "--options -h localhost,postgres-ha" When I restart postgres by systemctl...

Markus-