Changing the Shape or Hardware Configuration of a Database System

Change the shape or hardware configuration of an OCI Database with PostgreSQL database system.

After you provision a database system, you can change the shape to adapt to changes in performance requirements. For example, you might require a system with more OCPUs, or you might want to reduce costs by reducing the number of OCPUs. If the database system is using a flexible shape, you can scale the number of OCPUs and the amount of memory available to the system without selecting a new shape.

When changing the shape of a database system, the service replaces all existing nodes, one by one, to minimize cluster-wide downtime. Clients must reestablish existing PSQL connections during the replacement process.

For more information, including a list of shapes, see Supported Shapes.
Note

You can't change the series of a shape.

If you only need to change the configuration applied to a database system, see

    1. Open the navigation menu and click Databases. Under PostgreSQL, click 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 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:

    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:

    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.