search

hapostgres / pg_auto_failover

Postgres extension and service for automated failover and high-availability
Other
1.07k stars 113 forks source link

Expected a non-negative integer value on number of sync standbys #929

Closed dudewithaface closed 1 year ago

dudewithaface commented 1 year ago

Hello, I have been testing a setup with this tool. I have a monitor with 3 nodes connected and have tried to change the number of sync standbys. I run and get

$ pg_autoctl set formation number-sync-standbys 0
ERROR number-sync-standbys value 0 is not valid. Expected a non-negative integer value.

I also tried setting it to 1 but I get the same error.

Thanks in advance, Tobias

zlianzhuang commented 1 year ago

what is your version? i am right on v1.6.4

dudewithaface commented 1 year ago 
$ pg_autoctl --version
pg_autoctl version 1.6.3
pg_autoctl extension version 1.6
compiled with PostgreSQL 14.1 (Ubuntu 14.1-1ubuntu1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.2.0-12ubuntu1) 11.2.0, 64-bit
compatible with Postgres 10, 11, 12, 13, and 14

I installed through apt and I don't have any updates. I guess v1.6.4 isn't up yet.

DimCitus commented 1 year ago

Closing the issue because I can't reproduce here. Consider using the latest release of pg_auto_failover as listed on this page: https://github.com/citusdata/pg_auto_failover/releases. For that you might want to use apt.postgresql.org.