In some cases, you might want to connect to the current secondary server (if it is available). Applications can submit read-only queries to the secondary server, which can help you balance the workload across your servers.
An application can connect to secondary databases only in read-only mode. Note that a client can connect to the secondary server by using the following parameter values in the solid.ini configuration file in these servers (see HotStandby section):
▪ HSB.Connect parameter in the primary server
▪ HSB.Listen parameter in the secondary server
You can also use the following command to get the connection information for the partner of a server:
ADMIN COMMAND 'hotstandby cominfo'; (see HOTSTANDBY)
Thus, if you are connected to the current primary server, you can get the address of the current secondary server by using the cominfo query.