Changing the Shape or Hardware Configuration of a Database System

• Console
• CLI
• API

• 1. Open the navigation menu and select Databases. Under PostgreSQL, select DB Systems.
  2. (Optional) In the List scope section, under Compartment, select a compartment.
  3. Select the database system that you want to change.
  4. On the database system details page, from the actions menu, select Edit hardware configuration.
  5. Shape filter: Select either Flex or Fixed. Flexible shapes have a customizable number of OCPUs and amount of memory.
  6. Shape name: Select a shape.
     If using a flexible shape, enter values for the shape's OCPU count and Memory. For more information, including minimum and maximum values, see Supported Shapes.
  7. In the Configure extensions section, verify the configuration.

     Fixed configurations are associated with specific hardware details, and can only be applied to database systems with hardware configurations where OCPU and memory exactly match. If you changed to a fixed shape, and the existing configuration can't be applied, you must select an existing valid configuration, or select Create new configuration and extensions. For more information, see Creating a Configuration.

  8. Select Next.
  9. Review the changes that would occur if you changed the shape of the database system. The database system configuration's current values are shown along with the updated values.
  10. If the changes are acceptable, select Submit.

• Use the oci psql db-system update command and required parameters to update the shape of a database system with a fixed shape:

  Command

  CopyTry It

  oci psql db-system update --db-system-id <database_OCID> --shape <shape_name> [OPTIONS]

  To update the hardware configuration of a database system with a flexible shape, use the following command:

  Command

  CopyTry It

  oci psql db-system update --db-system-id <database_OCID> --shape <shape_name> --instance-memory-size-in-gbs <memory_in_gbs> --instance-ocpu-count <ocpu_count> [OPTIONS]

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

• Run the UpdateDbSystem operation with the shape attribute to update the shape of the database system.

  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.