Copying a Configuration

• Console
• CLI
• API

• 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. In the Configurations table, click the name of the configuration that you want to copy.
  4. On the Configuration details page, click Copy configuration.
  5. In the Copy configuration panel, provide values for the following:
     • Name: Enter a name for the configuration. Avoid entering confidential information.
     • Description: Enter a description for the configuration.
     • Select a Shape: You can't change this value when copying a configuration because system parameters are specific to OCPU count.
  6. In the User variables (read/write) section, modify existing variables as required:
     • Variable name: Select a user variable from the list.
     • Variable value: Select or enter a value for the variable.
  7. (Optional) Click + Another item to add another parameter to the list.
  8. Click 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]

  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.

  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.