Oracle Cloud Infrastructure Documentation

Changing the Configuration Applied to an OCI Database with PostgreSQL Database System

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

For more information about configurations, see OCI Database with PostgreSQL Configurations and Creating an OCI Database with PostgreSQL Configuration.
    1. On the Database systems list page, select the database system that you want to work with. If you need help finding the list page or the database system, see Listing OCI Database with PostgreSQL Database Systems.
      The database system's details page opens.
    2. Select Edit next to the existing configuration.
      The Configurations list opens.
    3. Select the name of an existing configuration.
    4. 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 <db-system_OCID> --db-configuration-params <configuration_parameters_in_JSON> [OPTIONS]

    To get your database system's OCID, see Listing Database Systems.

    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.