Updating the Performance Tier of an OCI Database with PostgreSQL Database System

Change the performance tier of an OCI Database with PostgreSQL database system.

For more information, see OCI Database with PostgreSQL Performance Tiers.

    1. On the Database systems list page, select the database system that you want to work with. If you need help finding the list page or the database system, see Listing OCI Database with PostgreSQL Database Systems.
      The database system's details page opens.
    2. Select Edit next to Performance tier.
      The Performance Tier list appears.
    3. Select the performance tier.
    4. Select Submit to update the database system performance tier.
  • Use the oci psql db-system update command and the --storage-details parameter to update the performance tier of a database system:

    oci psql db-system update --db-system-id <db-system_OCID> --storage-details <file://storage-details.json> [OPTIONS]

    To get your database system's OCID, see Listing Database Systems.

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

  • Run the UpdateDbSystem operation with the storageDetails attribute to update the performance tier of the database system.