Oracle Cloud Infrastructure Documentation

Restarting a 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 choose 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. 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 name of the database system that has the node that you want to restart.
    4. On the database system details page, under Resources, select Database system nodes.
    5. Select the Actions menu (Actions Menu) next to the node that you want to restart and select Restart.
    6. In the Restart database system window, verify the database system name.
    7. 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.
    8. 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.

    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.