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.
    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.
    5. In the Configure placement and hardware section, provide values for the following:
      • Select a compartment: Choose the compartment to contain the configuration list.
      • Select a Shape: Click Change Shape to choose the type 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.
    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.