is there anyway to get the backends IP address from the PID?

From: Tony Caduto <tony(dot)caduto(at)amsoftwaredesign(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: is there anyway to get the backends IP address from the PID?
Date: 2005-01-14 20:29:47
Message-ID: 41E82BBB.3090404@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
Does anyone know if there is a way to get the backends IP address from
the PID?
I am using the view pg_stat_activity and it would be nice if it would
also display the IP address along with the PID.

I can see the IP address when I do a ps -ef but it would be nice to be
able to get it via a sql command.

Thanks,

Tony Caduto
http://www.amsoftwaredesign.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard_D_Levine 2005-01-14 20:38:40 Re: MOVE
Previous Message Administrator 2005-01-14 20:28:24 postmaster listening on specified addresses