Thread

1. Process list in PostgreSQL 8.0

   Ericson Smith <eric@did-it.com> — 2005-03-10T18:01:50Z

   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 Agency Constellation Report
   
   

2. Re: Process list in PostgreSQL 8.0

   Tom Lane <tgl@sss.pgh.pa.us> — 2005-03-10T18:15:45Z

   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