Thread: Finding IP of front end

Finding IP of front end

From
Kelly Burkhart
Date:
Is there a way to query for the IP address (or other attributes) of the
front-end process attached to a given backend?  Perhaps something
similar to:

pg_stat_get_frontend_*( backendid )

-K

Re: Finding IP of front end

From
Steve Crawford
Date:
On Friday 20 May 2005 8:39 am, Kelly Burkhart wrote:
> Is there a way to query for the IP address (or other attributes) of
> the front-end process attached to a given backend?  Perhaps
> something similar to:
>
> pg_stat_get_frontend_*( backendid )

See the developer todo list
(http://www.postgresql.org/docs/faqs.TODO.html) onto which was
recently added "Add the client IP address and port to
pg_stat_activity"

So in short, not now, but later.

You can do it indirectly by first finding the PID of interest either
from the pg_stat_activity system view or "ps" and then use "netstat
-p" to find the connection associated with that PID.

Cheers,
Steve