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

From: Qing Zhao <qzhao(at)supplyfx(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: Kai Mildenberger <kai(at)supplyfx(dot)com>
Subject: killing a hung postgres process brings down the Postgres database server on MAC OS X!
Date: 2004-09-27 23:03:20
Message-ID: 6D0568B0-10D9-11D9-8F83-000A95AB8896@supplyfx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2004-09-27 23:07:28 Re: moving pg_xlog
Previous Message Oleg Bartunov 2004-09-27 20:35:54 Re: tsearch2 poor performance