Oracle Cloud Infrastructure Documentation

Creating a Configuration

Create an OCI Database with PostgreSQL database system configuration.

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 config.htm#variables__flexible.

    1. Open the navigation menu and click Databases. Under PostgreSQL, click Configurations.
    2. (Optional) In the List scope section, under Compartment, select a compartment.
    3. Click 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, provide the following:
      • Variable name: Select a 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 config.htm#variables__flexible.
    7. (Optional) Click + Another variable to add another variable to the configuration list.
    8. Click Create.

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

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

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

  • Run the CreateConfiguration operation to create a configuration.

    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.