killing a hung postgres process brings down the Postgres database server on MAC OS X!

Поиск
Список
Период
Сортировка
От Qing Zhao
Тема killing a hung postgres process brings down the Postgres database server on MAC OS X!
Дата
Msg-id 6D0568B0-10D9-11D9-8F83-000A95AB8896@supplyfx.com
обсуждение исходный текст
Ответы Re: killing a hung postgres process brings down the Postgres database server on MAC OS X!  (Rosser Schwarz <rosser.schwarz@gmail.com>)
Re: killing a hung postgres process brings down the Postgres database server on MAC OS X!  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi, there,

We are using PostgrSQL 7.3.4 on MAC OS X  G5  with Dual prpcessors and
8 GB RAM.

The postgreSQL server is our backend  that stores information for a
JBoss server.
Every once in a while, we see a process (thread) that processing a
request from
the JBoss server gets timed out.  Supposedly JBoss should clean up
after itself when it times out.
But it did not. If we do "kill -9 pid" to get rid of the deserted
process, it bring down the PG database
server entirely.

Is there a way to kill the dead processes/thread without really affect
the PG server?

Thanks!

Qing Zhao


В списке pgsql-admin по дате отправления:

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: tsearch2 poor performance
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: moving pg_xlog