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.
Note

You can't restart the primary node of a database system.
    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. Click the name of the database system that you want to add nodes to.
    4. On the DBSystem details page, under Resources, click DBSystem nodes.
    5. Click the Actions menu (Actions Menu) next to the node that you want to restart and choose Restart.
    6. In the Restart DB 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. Click 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.