[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