How to configure advanced PostgreSQL and MySQL Database Instance settings

Reviewed on January 06, 2025

Advanced settings allow you to modify the default configuration of your database engines.

Before you start

To complete the actions presented below, you must have:

• A Scaleway account logged into the console
• Owner status or IAM permissions allowing you to perform actions in the intended Organization
• A PostgreSQL or MySQL Database Instance

1. Click PostgreSQL and MySQL under Databases on the side menu. A list of your Database Instances displays.

2. Select the geographical region of the Instance you want to manage from the drop-down.

3. Click the Database Instance name or more icon > More info to access the database information page.

4. Click the Advanced settings tab.

   To add advanced settings, follow these steps:

• Click edit icon.
• Click + Add parameters.
• Select your parameter in the drop-down.
• Configure the value associated with your setting.
• Click validate icon to validate.

To delete them:

• Click edit icon in the advanced settings tab.
• Click delete icon next to the setting you wish to delete.
• Click validate icon to confirm your changes.