The host or hostaddr parameter of the connection string can be a mixture of multiple conmgr process destinations and the postmaster destination. The first connection from an application process is attempted in the listed order, and the second and subsequent connections are attempted in the order in which the previous connection was made. However, if a connection to the conmgr process is confirmed, subsequent connections are always attempted in the listed order.

For example, if conmgr1, conmgr2 are specified, and if conmgr1 does not initially know a server with the attributes specified in the target_session_attrs parameter, it will query conmgr2 for a destination. In the second and subsequent connections, since there was a connection to the conmgr1 process, the connection destinations are queried in the order of the listed conmgr1 and conmgr2.

Also, for example, if postmaster1, conmgr1 is specified, it will try to connect directly to the database instance initially named postmaster1. If this fails, it queries conmgr1 for a destination. On subsequent connections, since there was a connection to the conmgr1 process, it queries the listed postmaster1, then conmgr1, for connections.