You can change the configuration parameters of your Ubicloud PostgreSQL instance
by using the Configuration view. Here, you can configure both PostgreSQL and
PgBouncer parameters.
To configure a new parameter, enter the paramter name and value in the new key
and value input fields. Confirm the addition by clicking the “Save” button. You
can add multiple parameters in one go by using the ”+” button.To change a configuration parameter, change the key or value in the input
fields. You can also reset a parameter to its default value by clicking the
“Delete” button next to it. Confirm your changes by clicking the “Save” button.We support configuring basically all PostgreSQL and PgBouncer parameters. For a
list of supported parameters, see the PostgreSQL documentation
and the PgBouncer documentation.All changes made to the configuration parameters are typically persisted to the
instance within one minute. If modifying a parameter requires a restart of the
database server, the change will be applied after the next restart. You
can trigger a restart manually from the Settings view, described below.
Maintenance Windows are periods during which Ubicloud can perform maintenance
tasks on your instance. This can be used to decrease the impact of maintenance
tasks like resizing on your database.You can set up a maintenance window by selecting a 2-hour window from the
provided dropdown. The time window uses the UTC timezone.