Runaway SELECT - Mailing list pgsql-admin

From Chris Gamache
Subject Runaway SELECT
Date
Msg-id 20020813151440.37503.qmail@web13807.mail.yahoo.com
Whole thread Raw
In response to Re: pg_dump fails..does not like "text" data..  (Chris Gamache <cgg007@yahoo.com>)
List pgsql-admin
<embarassed>Fixed the subject line...</embarassed>

root@database:~# ps -auxww | grep SELECT
postgres 10906 99.9  0.4  7596 4008 ?        R    Jul31 18445:54 postgres:
postg
res database 192.168.2.1 SELECT

Any clues on how to stop this runaway select without having to force the
whole
database down? This was started from an ODBC connection. Obviously the
connection timed out...  :)

Can I kill -TERM 10906 ?
Can I kill -KILL 10906 ?

CG


__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Leftover processes on shutdown - Debian+JDBC
Next
From: "Robert M. Meyer"
Date:
Subject: Re: Leftover processes on shutdown - Debian+JDBC