hapostgres / hapostgres/pg_auto_failover
Monitor ERROR: invalid input syntax for type integer: ""
- Dominant language
- C
- Stars
- 1.4k
- Forks
- 142
- Avg merge
- 5h 8m
- Merged PRs (30d)
- 1
Description
Hello,
On 4 Debian 12 nodes (3 nodes + 1 monitor node), I've installed postgresql 16 and postgresql-16-auto-failover.
Packages come from postgres repository (https://apt.postgresql.org/pub/repos/apt)
I am testing postresql switchover and I run "pg_autoctl perform switchover --formation default --group 0" on a node
Looking at journalctl log files for the service, everything looks fine and "pg_autoctl show state" is showing the switchover complete. However, at the cli, before the completion of the switchover I get
Why am I getting this error? Does it mean that I can't trust the failover also if it seems that happened?
---
This is pg_autofailover version
`pg_autoctl version 2.1-2.pgdg120+1
pg_autoctl extension version 2.1
compiled with PostgreSQL 16.1 (Debian 16.1-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
compatible with Postgres 11, 12, 13, 14, 15, and 16`
Contributor guide
Assessment
This issue has not been assessed yet.