Re: Enhance pg_stat_wal_receiver view to display connected host

On Tue, Jan 16, 2018 at 2:55 PM, Michael Paquier <michael.paquier@gmail.com> wrote:

Note that I still find this API confusing, it seems to me that just
sorting out the confusion problems with PQhost and then use it would be
more simple.

OK, Understood. Even if the confusion problems with PQhost that are

discussed in [1] are solved, we need two new API's that are required to\

display the proper remote server details.

PQhostNoDefault - Similar like PQhost but doesn't return default host details.

Displaying default value always some confuse even if the user doesn't provide

the host details, so to avoid that confusion, we need this function.

PQhostaddr - Return hostaddr used in the connection. 

Without PQhostaddr() function, for the connections where the host is not

specified, it will be difficult to find out to remote server.

With the above two new API's we can display either string or individual columns

representation of remote server.