Settings
You can modify configuration parameters and manage instance settings for your Managed Postgres instance through the Settings tab in the sidebar.
Service actions and scaling
The Service actions toolbar provides controls for managing your Managed Postgres instance:
- Reset password: Update the superuser password (only when the instance is
Running) - Restart: Restart the database instance (only when the instance is
Running) - Delete: Delete the instance
The Scaling section allows you to change the instance types of your primary and standbys to increase or decrease computing resources and storage capacity. See scaling page for more details.
Changing configuration parameters
To modify a parameter, select the Edit parameters button. Select the parameters you need to modify and change their values accordingly. Once you're satisfied with your changes, press the Save Changes button.
All changes made to the configuration parameters are typically persisted to the instance within one minute. Some parameters require a database restart to take effect. These changes will be applied after the next restart, which you can trigger manually from the Service actions toolbar.
Refer to https://www.postgresql.org/docs/current/runtime-config.html for the official documentation on the configuration parameters. The list of parameters available to set will be extended soon. In the meantime, contact support to request a parameter not currently supported.
