Re: [GENERAL/OFF-TOPIC]: identifying runaway DB clients

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ed Loehr <pggeneral(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL/OFF-TOPIC]: identifying runaway DB clients
Date: 2002-04-18 20:24:08
Message-ID: 2973.1019161448@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ed Loehr <pggeneral(at)bluepolka(dot)net> writes:
> This is slightly off-topic, but I have some unidentified HPUX
> processes running on an HPUX box with a PG server and hammering the
> database. I'm trying to identify them. In Linux, I'd map from the
> connecting port to the client process via fuser -n tcp, but HPUX fuser
> doesn't appear to support tcp port mapping. Does anyone know how to
> map an HPUX port to the proc pid?

I use lsof (not standard equipment on HPUX, but readily available).

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Roy Souther 2002-04-18 22:04:09 Paradox to PostgreSQL?
Previous Message Vaclav Kulakovsky 2002-04-18 18:23:49 How to find backend which blocking ?