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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL/OFF-TOPIC]: identifying runaway DB clients
Дата
Msg-id 2973.1019161448@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [GENERAL/OFF-TOPIC]: identifying runaway DB clients  (Ed Loehr <pggeneral@bluepolka.net>)
Список 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 по дате отправления:

Предыдущее
От: Ed Loehr
Дата:
Сообщение: Re: Questions on 7.2.1 query plan choices
Следующее
От: Roy Souther
Дата:
Сообщение: Paradox to PostgreSQL?