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 tendancy to 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 a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general