Oracle Cloud Infrastructure Documentation

Creating a Configuration

Create an OCI Database with PostgreSQL database system configuration to manage variables and extensions.

Important

OCI Database with PostgreSQL provides optimized default configurations out of the box targeting a specific shape. Only advanced users might need to change and manage them. For more information, see PostgreSQL reference manual.

When creating a configuration, select either a fixed configuration or a flexible configuration.

A fixed configuration is associated with specific hardware details, and can only be applied to database systems with hardware configurations where OCPU and memory exactly match those details.

A flexible configuration can be applied to database systems with differing hardware configurations. If a database system uses a flexible configuration, you can update its hardware configuration without the need to change configurations. Flexible configurations let you use integer expressions for some variable values. For more information, see Flexible Configurations and Integer Variables.

    1. Open the navigation menu and select Databases. Under PostgreSQL, select Configurations.
    2. (Optional) In the List scope section, under Compartment, select a compartment.
    3. Select Create configuration.
    4. In the Create configuration window, provide values for the following:
      • Name: Enter a name for the configuration list. Avoid entering confidential information.
      • Description: Enter a description for the configuration list.
      • 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 a specific, fixed shape and matching hardware configuration. For more information, see Supported Shapes.
    5. In the Configure placement and hardware section, provide values for the following:
      • Select a compartment: Select the compartment to contain the configuration.
      • Shape series: Select a processor group.
        • AMD: (Flexible) Standard shapes that use current-generation AMD processors.
        • Intel: (Flexible) Standard shapes that use current-generation Intel processors.
      • Shape name: If using a fixed shape, select the shape of database system that this configuration list can be applied to.
    6. 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.
    7. In the Configure extensions section, provide the following information:
      • PostgreSQL extensions: Select an extension or extensions from the list.
      • Select + Another variable if an extension supports configurable variables.
      • Variable name: Select a variable 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.

    8. (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.
    9. Select Create.

  • Use the oci psql configuration create command and required parameters to create a configuration:

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

    A list of admin-enabled extensions can be specified using the oci.admin_enabled_extensions configuration parameter as part of db-configuration-overrides. For example:

    oci psql configuration create --compartment-id <compartment_OCID> --db-version <db_version> --display-name <display_name> --db-configuration-overrides <file://db-configuration-overrides.json> [OPTIONS]

    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 to create a configuration.

    Use dbConfigurationOverrides along with a configKey of oci.admin_enabled_extensions='<extension1,extension2>' and the required value to enable extensions for the configuration. 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.