Confirming Connection Information

You can use a client tool to connect to a database through a the primary node of the database in the database. Before the connection, obtain the IP address and the primary node of the database port number of the server where the primary node of the database is deployed.

Procedure

1. Log in as the OS user omm to the primary node of the database.

2. Run the gs_ctl query -D /home/dbuser/env_test/data command to query openGauss instances.

   gs_ctl query -D /home/dbuser/env_test/data
   

   [2022-01-08 17:21:26.569][15657][][gs_ctl]: gs_ctl query ,datadir is /home/dbuser/env_test/data 
    HA state:           
   	local_role                     : Primary
   	static_connections             : 1
   	db_state                       : Normal
   	detail_information             : Normal
   
    Senders info:       
   	sender_pid                     : 15464
   	local_role                     : Primary
   	peer_role                      : Standby
   	peer_state                     : Normal
   	state                          : Streaming
   	sender_sent_location           : 0/4000148
   	sender_write_location          : 0/4000148
   	sender_flush_location          : 0/4000148
   	sender_replay_location         : 0/4000148
   	receiver_received_location     : 0/4000148
   	receiver_write_location        : 0/4000148
   	receiver_flush_location        : 0/4000148
   	receiver_replay_location       : 0/4000148
   	sync_percent                   : 100%
   	sync_state                     : Sync
   	sync_priority                  : 1
   	sync_most_available            : Off
   	channel                        : 10.244.42.115:65301-->10.244.181.97:35446
   
    Receiver info:      
   No information
   

   In the preceding information, the IP address of the server where the primary database node instance is deployed is 10.244.42.115. The data path of the primary node of the database is /home/dbuser/env_test/data. Primary indicates the primary database node. Normal indicates that openGauss is available, the data has redundancy backup, all processes are running, and the primary/standby relationship is normal.

3. Confirm the port number of the primary node of the database.

   View the port number in the postgresql.conf file of the primary node of the database path, which is queried in 2. The command is as follows:

   cat /srv/BigData/gaussdb/data1/dbnode/postgresql.conf | grep port
   

   port = 8000    # (change requires restart)
   #comm_sctp_port = 1024   # Assigned by installation (change requires restart)
   #comm_control_port = 10001  # Assigned by installation (change requires restart)
         # supported by the operating system:
         # e.g. 'localhost=10.145.130.2 localport=12211 remotehost=10.145.130.3 remoteport=12212, localhost=10.145.133.2 localport=12213 remotehost=10.145.133.3 remoteport=12214'
         # e.g. 'localhost=10.145.130.2 localport=12311 remotehost=10.145.130.4 remoteport=12312, localhost=10.145.133.2 localport=12313 remotehost=10.145.133.4 remoteport=12314'
         #   %r = remote host and port
   alarm_report_interval = 10
   support_extended_features=true
   

   8000 is the port number of the primary node of the database.