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 click Databases. Under PostgreSQL, click DB Systems.
2. (Optional) In the List scope section, under Compartment, select a compartment.
3. Click the name of the database system that contains the nodes that you want to get details about.
4. On the DBSystem details page, under Resources, click DBSystem nodes.
5. Next to the node that you're interested in, click the the Actions menu (), and 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.