Thread: Process list in PostgreSQL 8.0

Hi All,

We upgraded to Postgres 8.0 on a Linux (RHEL) machine yesterday and
notice a slightly different list when looking at the processes (ps).

11679 ? S 0:00 postgres: iacm didit 216.187.113.78(56640) idle
11680 ? S 0:07 postgres: iacm didit 216.187.113.78(56641) idle
11863 ? S 0:00 postgres: iacm didit 216.187.113.89(41860) idle
11864 ? R 0:09 postgres: iacm didit 216.187.113.89(41861) INSERT
11906 ? S 0:00 postgres: iacm didit 24.189.251.57(49023) idle

Just wondering what the values in parenthesis are and how can we use 'em.

--
Warmest regards,

Ericson Smith
Programmer
Did-it Search Marketing
Raise Your Expectations...
---
http://www.did-it.com
55 Maple Avenue, 3rd Floor
Rockville Center, NY 11570

P: 800.932.7761 Ext 237
E: eric@did-it.com

Jupiter Research rates Did-it the #1 Search Engine Marketing agency for market suitability in Search Engine Marketing
AgencyConstellation Report 

Ericson Smith <eric@did-it.com> writes:
> 11679 ? S 0:00 postgres: iacm didit 216.187.113.78(56640) idle
> 11680 ? S 0:07 postgres: iacm didit 216.187.113.78(56641) idle
> 11863 ? S 0:00 postgres: iacm didit 216.187.113.89(41860) idle
> 11864 ? R 0:09 postgres: iacm didit 216.187.113.89(41861) INSERT
> 11906 ? S 0:00 postgres: iacm didit 24.189.251.57(49023) idle

> Just wondering what the values in parenthesis are and how can we use 'em.

Client-side port numbers, IIRC.  So you can figure out which connection
is which ...

            regards, tom lane