Re: killing a hung postgres process brings down the Postgres database server on MAC OS X! - Mailing list pgsql-admin

while you weren't looking, Qing Zhao wrote:

[...]

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

See: http://www.postgresql.org/docs/7.3/static/postmaster-shutdown.html

I have occasionally had to kill -9 a backend, but it's never been
pleasant.  Avoid if at all possible.

/rls

--
:wq