Seems like it is not possible to change to parameters to "remote_apply" It is not supported yet in Azure PostgreSQL Flexible.
Unable to set "synchronous_commit" the parameter for Azure Database for PostgreSQL flexible server instance
Mahesh Bathina
0
Reputation points
Hi Everyone,
we are using Postgresql Flexible server instance in our product. Now, we want to integrate pgpool in our product to load-balance the queries between primary and replica databases. For this issue, we tried to set synchronous_commit to remote_apply, but it is not supporting to edit the parameter.
we are facing data consistency between primary and replica because of delay between both the instances. can you please provide some solution
1 answer
Sort by: Most helpful
-
Oury Ba-MSFT 18,616 Reputation points Microsoft Employee
2024-09-09T21:40:25.24+00:00