Skip site navigation (1) Skip section navigation (2)

Re: Understanding ps -ef "command" column

From: "Douglas McNaught" <doug(at)mcnaught(dot)org>
To: "David Jaquay" <djaquay(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Understanding ps -ef "command" column
Date: 2008-02-22 16:28:34
Message-ID: (view raw or whole thread)
Lists: pgsql-general
On 2/22/08, David Jaquay <djaquay(at)gmail(dot)com> wrote:
> When I do a ps -ef, in the command column, I see:
> postgres: postgres dbname 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).


In response to


pgsql-general by date

Next:From: Alvaro HerreraDate: 2008-02-22 16:30:06
Subject: Re: text and bytea
Previous:From: David JaquayDate: 2008-02-22 16:18:22
Subject: Understanding ps -ef "command" column

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group