On Feb 22, 2008, at 10:28 AM, Douglas McNaught wrote:
On 2/22/08, David Jaquay <djaquay@xxxxxxxxx> wrote:
When I do a ps -ef, in the command column, I see:
postgres: postgres dbname 10.170.1.60(57413) idle
I get all of this, except the "57413". What does this mean, and more
importantly, how can I tie that number back to a connection that I've
acquired via JDBC?
At a guess, it's the ephemeral port number used by the client
connection. It might be hard to track back in Java because I don't
think the JDBC driver gives you access to the underlying Socket object
(which you could query to find out its local port).
See the lsof unix tool for a good way to track which processes are
communicating via that port number.
Erik Jones
DBA | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
