Update content

How to configure advanced PostgreSQL and MySQL Database Instance settings

Reviewed on 13 June 2023 • Published on 11 May 2019

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

Security & Identity (IAM):

You may need certain IAM permissions to carry out some actions described on this page. This means:

  • you are the Owner of the Scaleway Organization in which the actions will be carried out, or
  • you are an IAM user of the Organization, with a policy granting you the necessary permission sets
Requirements:
Important:

Changing the advanced settings can have an impact on the performance of your Database Instance.

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

  2. Click the database name or «See more Icon» > More info to access the database information page.

  3. Click the Advanced settings tab.

    To add advanced settings follow these steps:

  • Click Add advanced setting.
  • Click Add parameters.
  • Select your parameter from the drop-down list.
  • 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.
See Also