Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump fails..does not like "text" data.. - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump fails..does not like "text" data..
Date
Msg-id 26719.1029255237@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump fails..does not like "text" data..  (Chris Gamache <cgg007@yahoo.com>)
List pgsql-admin
Tree view 
Chris Gamache <cgg007@yahoo.com> writes:
> 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 ?

kill -INT is a good idea, the others are bad ideas (and will in fact
lead to a database restart).

            regards, tom lane

pgsql-admin by date:

Previous
From: "Robert M. Meyer"
Date:
Subject: Re: Leftover processes on shutdown - Debian+JDBC
Next
From: Thomas O'Connell
Date:
Subject: Re: performance tuning: shared_buffers, sort_mem; swap