Cannot connect on 6432 while promoting read replica

Question

I use Azure Flexible Server for PostgreSQL and Read Replica. To the main server I connect on 6432 port since using pgbouncer. Before promoting replica I turn on pgbouncer (using az cli) on replica as well but after promotion I cannot connect on port 6432. Connection on 5432 works fine. I observed that while turning pgbouncer from the Azure Portal it usually works fine but while choosing AZ CLI it barely works. According to documentation server restart is not needed and when I query the server parameters I can see that value is correctly set to 'true'. How can I make sure that after promoting replica I can still connect on pgbouncer port?

Answer 1

Hi Nowak, Wawrzyniec •,

Welcome to Microsoft Q&A forum.

As I understand, you Cannot connect on 6432 while promoting read replica in Azure Database for PostgreSQL Flexible server.

Could you please try reloading pgbouncer and check if that works?

The Promote to primary server action is currently in preview. The Promote to independent server and remove from replication action is backward compatible with the previous promote functionality.

Awaiting your reply, thanks.