Revert one server parameter to its default
APPLIES TO: 
Azure Database for PostgreSQL - Flexible Server
This article provides step-by-step instructions to revert one server parameter to its default of an Azure Database for PostgreSQL flexible server.
Steps to revert one server parameter to its default
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 parameter whose current value you want to revert to its default, select the ellipsis at the right end side of the scree, and select Reset to default.
Important
For parameters designated as read-only, selecting the ellipsis doesn't pop up the Reset to default menu option.
If the column Parameter type for the parameter you're trying to reset to default is equal to Static, the server requires a restart for the change 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.
