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.
- On the Database systems list page, select the database system that contains the node that you want to work with. If you need help finding the list page or the database system, see Listing Database Systems.
- On the database system details page, under Resources, select Database system nodes.
-
Select the Actions menu
next to the node that you want to restart and select Restart.
- In the Restart database system window, verify the database system name.
-
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.
- Select Restart.
Use the
oci psql db-system restart-db-instance-incommand 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.