Re: [GENERAL/OFF-TOPIC]: identifying runaway DB clients - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL/OFF-TOPIC]: identifying runaway DB clients
Date
Msg-id 2973.1019161448@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL/OFF-TOPIC]: identifying runaway DB clients  (Ed Loehr <pggeneral@bluepolka.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: Re: Questions on 7.2.1 query plan choices
Next
From: Roy Souther
Date:
Subject: Paradox to PostgreSQL?