Oracle Cloud Infrastructure Documentation

Editing a 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 Configurations.
    2. On the details page, select Edit compatible shapes.
    3. In the Edit compatible shapes panel, 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]

    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.

    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.