Oracle Cloud Infrastructure Documentation

Restarting an OCI Database with PostgreSQL Database System Node

Restart a node of an OCI Database with PostgreSQL database system.

Restarting doesn't change connectivity configuration to the database system.

 When you restart a database node, you can select between two restart types:

  • Normal: Only the database processes are restarted. This takes less than a minute.
  • Reboot: The underlying Compute instance is rebooted, which also restarts PostgreSQL processes. This can take several minutes.
    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 Database system nodes.
      The Database system nodes page appears.
    3. Find the node you want to restart. From the Actions menu, select Restart.
      The Restart database system panel opens.
    4. Verify the database system name.
    5. Select the Shutdown Type:
      • Normal: Only the database processes are restarted. This takes less than a minute.
      • Node reboot: The underlying Compute instance is rebooted, which also restarts PostgreSQL processes. This can take several minutes.
    6. Select Restart.

  • Use the oci psql db-system restart-db-instance-in command and required parameters to restart a node:

    oci psql db-system restart-db-instance-in --db-instance-id <db_instance_OCID> --db-system-id <db_system_OCID> --restart-type <restart_type> [OPTIONS]

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

  • Run the RestartDbInstanceInDbSystem operation to restart a node.