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.
- Open the navigation menu and select Databases. Under PostgreSQL, select DB Systems.
- (Optional) In the List scope section, under Compartment, select a compartment.
- Select the name of the database system that has the node that you want to restart.
- 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.