Oracle Cloud Infrastructure Documentation

Copying an OCI Database with PostgreSQL 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 OCI Database with PostgreSQL Configurations.
      The configuration's details page opens.
    2. From the Actions menu, select, Copy configuration and extensions.
      The Copy configuration and extensions panel opens.
    3. Select Create.

    Basic information

    Enter the following information:

    • Name: Enter a name for the configuration list. Avoid entering confidential information. If you do not provide a name, the original configuration's name is used with "copy of" prepending it.
    • Description: (Optional) Enter a description for the configuration list.
    • PostgreSQL version: Select a major version of the PostgreSQL database from the list.
    • Configuration shape type: Select one of the following configuration shape options:
      • Flex: Allows you to configure the amount of OCPU and memory.
      • Fixed: Come with a set values for OCPU and memory.

    Advanced options

    Under Tags, select Add tag to apply tagging to your database system.

    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.

    Placement and hardware

    Enter the following information:

    • Compartment: Select the compartment to contain the configuration.
    • Configuration shape type: Select one of the following configuration shape type options:
      • Flex: You can apply flexible configurations to database systems with varying shapes and hardware configurations. 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 OCI Database with PostgreSQL Supported Shapes.
      • Fixed: A fixed configuration can only be applied to a database system with specific, fixed shapes and matching hardware configuration. Select a processor group as the Shape series and then select the Shape name.

        Details of the shape you selected are displayed.

    User variables (read/write)

    Enter the following information:

    • Variable name: Select a user variable from the list.
    • Variable value: Select or enter a value for the variable.

    Select Add variable to create another 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.

    System varibles (read-only)

    The system variables are displayed for your reference. You can't make modify them.

    Extensions

    PostgreSQL extensions: (Optional) Select one or more extensions from the list.

    Select Copy configuration.

    The configuration you copied with its new name is displayed in the Configurations list.

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

  • 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]

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

    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 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 Extensions for OCI Database with PostgreSQL.