This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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
Are you looking to set the parameter synchronous_commit" to "ON" for your Azure PostgreSQL flexible server?
Regards,
Oury
I want to set the synchronous_commit to "remote_apply", but that is not available on UI
Seems like it is not possible to change to parameters to "remote_apply" It is not supported yet in Azure PostgreSQL Flexible.
@MAHESH BATHINA Please don't forget to mark as accept answer if the reply was helpful.
Regards,
Oury