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.
You can't change the series of a shape.
If you only need to change the configuration applied to a database system, see
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.