On Wed, Nov 09, 2011 at 03:02:00PM -0700, Gauthier, Dave wrote:
> pg_ctl --help lists the various SIGNALNAME options to use with "pg_ctk kill"...
>
> Allowed signal names for kill:
> HUP INT QUIT ABRT TERM USR1 USR2
>
> I can't find a description of what each does. I'd like to abort just the procpid I enter, but using ABRT has a
tendancyto kill lots of other stuff too.
It's a little hard to find, but what various signals do to the back
end is contained in the postgres (server process) manual page:
http://www.postgresql.org/docs/9.1/interactive/app-postgres.html
I suspect the line you want is, "To cancel a running query, send the
SIGINT signal to the process running that command."
A
--
Andrew Sullivan
ajs@crankycanuck.ca