adnanhamdussalam

Thank you for the update. You mean to use virtual ip as node ip and configure it in pg auto failover?

I am using haproxy and in haproxy I have mentioned the pgbouncer port 6432 to connect the standby database (.33) and I also having another standby db (.34) against port...

Hi , Any idea I have also try with older version of pgbouncer but still facing the same issue psql gets connect without any error but it always connects with...

Thank you for the update. Then why it connects when I change the auth_type to trust and pgbouncer if the issue is at haproxy then why it is connecting when...

Sep 05 06:57:38 testbed04 pgbouncer[122354]: S-0x55f092a3f5a0: ctafiniti/postgres@(bad-af):0 inet socket: 10.114.16.33 Any idea what (bad-af) means ?

Did you get the time to recreate on your local machine ? I have also try with auth_type = hba but same issue but only when I use auth_type =...

mydb=# show synchronous_commit mydb-# ; synchronous_commit -------------------- on

PFB the postgresql settings as I am using pg_auto_failover: [postgres@testbed12 pgdatabase]$ cat postgresql-auto-failover.conf # Settings by pg_auto_failover shared_preload_libraries = pg_stat_statements listen_addresses = '10.114.16.69' port = 5432 max_wal_senders = 12 max_replication_slots...

Yes Sure. The parameter is set at database level. show synchronous_standby_names; -[ RECORD 1 ]-------------+-- synchronous_standby_names | * mydb=# select * from pg_stat_replication; -[ RECORD 1 ]----+------------------------------ pid | 1360681...

@CyberDem0n Thank you for the update one more observation for Patroni initiates the two pg_basbackup processes: [postgres@testbed04 data]$ systemctl status patroni ● patroni.service - Runners to orchestrate a high-availability PostgreSQL...