Set the value of one or more server parameters
APPLIES TO: 
Azure Database for PostgreSQL - Flexible Server
This article provides step-by-step instructions to set the value of one or more server parameters of an Azure Database for PostgreSQL flexible server.
Steps to set the value of one or more server parameters
Using the Azure portal:
Select your Azure Database for PostgreSQL flexible server instance.
In the resource menu, under the Settings section, select Server parameters.
Locate the read-write parameters whose current values you want to change, set them to the new desired values, notice that an informational message indicates how many server parameter changes aren't saved yet, and select Save.
If the column Parameter type for any of the parameters changed is equal to Static, the server requires a restart for the changes to take effect. In that case, a dialog pops up so that you can select if you want to:
- Save and Restart: In case you want to persist all changes made to all parameters whose values were modified, and immediately after restart the server for any changes to static parameters to take effect.
- Save only: In case you want to persist all changes made to all parameters whose set values changed, but want to defer the server restart to a later time. Until you don't complete the server restart action, changes made to any static server parameters don't take effect.
- Cancel: To not implement any changes yet.
