Oracle Cloud Infrastructure Documentation

Editing an OCI Database with PostgreSQL Configuration's Shape Compatibility

Change the database system shapes that an OCI Database with PostgreSQL configuration are compatible with.

If you created a configuration and set its variables to meet the needs of specific workloads, you might want to reuse that configuration across multiple database systems, regardless of the shape of those database systems. Configurations can have their compatibility updated if you need to make changes after it's been created.

You can't change an existing configuration's variables and values after it's been created, but if the configuration supports flexible shapes, you can use integer expressions for some values. For more information, see Flexible Configurations and Integer Variables.

    1. On the Configurations list page, select the configuration that you want to work with. If you need help finding the list page or the configuration, see Listing OCI Database with PostgreSQL Configurations.
      The configuration's details page opens.
    2. From the Actions menu, select Edit compatible shapes.
      The Edit compatible shapes panel opens.
    3. Select the shapes that this configuration can be applied to.
    4. Select Update.

  • Use the oci psql configuration update command and required parameters to update a configuration's shape compatibility:

    oci psql configuration update --configuration-id <configuration_ocid [OPTIONS]

    To get your configuration's OCID, see Listing Configurations.

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

  • Run the UpdateConfiguration operation to update a configuration's shape compatibility.