Getting an OCI Database with PostgreSQL Database System 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. On the Database systems list page, select the database system that you want to work with. If you need help finding the list page or the database system, see Listing OCI Database with PostgreSQL Database Systems.
  The database system's details page opens.
2. Select Database system nodes.
  The Database system nodes page appears.
3. Select the node you want to work with.
The details page of the node you selected opens.
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.