Обсуждение: [GENERAL/OFF-TOPIC]: identifying runaway DB clients

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?

Ed Loehr <pggeneral@bluepolka.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