Re: How to determine server's own IP address? inet_server_addr not working

[Ian Lawrence Barwick <barwick@xxxxxxxxx>]

2021年2月22日(月) 8:42 David G. Johnston <david.g.johnston@xxxxxxxxx>:

On Sun, Feb 21, 2021 at 4:38 PM Guyren Howe <guyren@xxxxxxxxx> wrote:

The documentation says that inet_server_addr() does this, but on our servers it is returning nothing.

"Returns the IP address on which the server accepted the current connection, or NULL if the current connection is via a Unix-domain socket."

You will need to demonstrate that the connection you are checking from isn't being made via a Unix-domain socket.

Note also there's a bug in current versions where this function will erroneously

return NULL if executed by a parallel worker, see [1]. This is fixed in HEAD but
hasn't been backpatched [2].

[1] https://www.postgresql.org/message-id/CAD21AoAT4aHP0Uxq91qpD7NL009tnUYQe-b14R3MnSVOjtE71g@xxxxxxxxxxxxxx

[2] https://git.postgresql.org/pg/commitdiff/5a6f9bce8dabd371bdb4e3db5dda436f7f0a680f

Regards

Ian Barwick

--

EnterpriseDB: https://www.enterprisedb.com