Oracle Cloud Infrastructure Documentation

Changing the Configuration Applied to a Database System

Change the configuration applied to an OCI Database with PostgreSQL database system.

For more information about configurations, see Managing OCI Database with PostgreSQL Configurations and Creating a Configuration.
    1. Open the navigation menu and click Databases. Under PostgreSQL, click DB Systems.
    2. (Optional) In the List scope section, under Compartment, select a compartment.
    3. Select the database system that you want to change.
    4. On the details page, next to the existing configuration, select Edit.
    5. In the Configurations list, select the name of an existing configuration.
    6. Select Submit.

  • Use the oci psql db-system update command and required parameters to update the configuration of a database system:

    oci psql db-system update --db-system-id <database_OCID> --db-configuration-params <configuration_parameters_in_JSON> [OPTIONS]

    For a complete list of parameters and values for CLI commands, see the CLI Command Reference.

  • Run the UpdateDbSystem operation with the dbConfigurationParams attribute to update the configuration of the database system.

    For information about using the API and signing requests, see REST API documentation and Security Credentials. For information about SDKs, see SDKs and the CLI.