Getting a Node's Details

Get details about a node of an OCI Database with PostgreSQL database system.

Details about a node include its private IP address, FQDN, and its PostgreSQL port.

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 contains the nodes that you want to get details about.
4. On the database system details page, under Resources, select Database system nodes.
5. Next to the node that you're interested in, select the the Actions menu (), and then select View details.
Use the oci psql db-system get-primary-db-instance command and required parameters to get details about the primary node of a database system:
oci psql db-system get-primary-db-instance --db-system-id <database_OCID> [OPTIONS]
Use oci psql db-system get command and required parameters to get details about a database system, including its nodes:
oci psql db-system get --db-system-id <database_OCID> [OPTIONS]
For a complete list of parameters and values for CLI commands, see the CLI Command Reference.
Run the GetPrimaryDbInstance operation to get details about the primary node of a database system.

Run the GetDbSystem operation to get details about a database system, including its nodes.
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.