Oracle Cloud Infrastructure Documentation

Copying a Configuration

Copy an existing OCI Database with PostgreSQL database system configuration so that its variables and extensions can be updated.

    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 configuration's details page, select Copy configuration and extensions.
    3. In the Copy configuration and extensions panel, provide the following basic information:
      • Name: Enter a name for the configuration list. Avoid entering confidential information.
      • Description: Enter a description for the configuration list.
    4. In the Configure placement and hardware section, provide values for the following:
      • Compartment: Select the compartment to contain the configuration.
      • Configuration shape type: Select either Flex or Fixed. Flexible configurations can be applied to database systems with varying shapes and hardware configurations. A fixed configuration can only be applied to a database system with specific, fixed shapes and matching hardware configuration.
      • If you're creating a flexible configuration, select the Compatible shape series of the database systems that this configuration can be applied to. By default, the widest group of compatible shapes is selected. For more information, see Supported Shapes.

      • If you're creating a fixed configuration, select a processor group as the Shape series and then select the Shape name.

    5. In the User variables (read/write) section, add or update existing variables as needed:
      • Variable name: Select a user variable from the list.
      • Variable value: Select or enter a value for the variable.
      Tip

      If the configuration supports flexible shapes, you can use integer expressions for some values. For more information, see Flexible Configurations and Integer Variables.
    6. In the Configure extensions section, provide the following information:
      • PostgreSQL extensions: Select an extension from the list.
      • Variable name: Select a variable for the selected extension from the list.
      • Variable value: Select or enter a value for the variable.

      For more information, see Supported PostgreSQL Extensions for OCI Database with PostgreSQL.

    7. (Optional) Show advanced options: If you have permissions to create a resource, then you also have permissions to apply free-form tags to that resource. To apply a defined tag, you must have permissions to use the tag namespace. For more information about tagging, see Resource Tags. If you're not sure whether to apply tags, skip this option or ask an administrator. You can apply tags later.
    8. Select Create.

  • Use the oci psql configuration create command and required parameters with existing information from oci psql default-configuration get to copy a default configuration:

    oci psql default-configuration get --configuration-id <configuration_OCID> [OPTIONS]
    oci psql configuration create --compartment-id <compartment_OCID> [OPTIONS]

    Use --db-configuration-overrides along with a key of oci.allowed_extensions to enable extensions for the configuration. For more information, see Supported PostgreSQL Extensions for OCI Database with PostgreSQL.

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

  • Run the CreateConfiguration operation with existing information to copy a configuration.

    Use dbConfigurationOverrides along with a configKey of oci.allowed_extensions to enable extensions. For more information, see Supported PostgreSQL Extensions for OCI Database with PostgreSQL.

    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.