Re: [GENERAL] Backend process that won't die

2011-09-06 Thread Susan Cassidy
-Original Message- > From: Tom Lane [mailto:t...@sss.pgh.pa.us] > Sent: Tuesday, September 06, 2011 9:57 AM > To: Susan Cassidy > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Backend process that won't die > Susan Cassidy writes: >> I have

Re: [GENERAL] Backend process that won't die

2011-09-06 Thread Tom Lane
Susan Cassidy writes: > I have a couple of backend processes that are "stuck", and do not respond to > a pg_cancel_backend. This is PostgreSQL 8.3.5. The pg_cancel_backend > returns true, but the process keeps running. I have also done a "kill 12345" > from the command-line, with no effect.

[GENERAL] Backend process that won't die

2011-09-06 Thread Susan Cassidy
I have a couple of backend processes that are "stuck", and do not respond to a pg_cancel_backend. This is PostgreSQL 8.3.5. The pg_cancel_backend returns true, but the process keeps running. I have also done a "kill 12345" from the command-line, with no effect. The processes are running a "s