SIGNALNAME in "pg_ctl kill"

The manual section on the postmaster process has some info:

http://www.postgresql.org/docs/current/static/app-postgres.html

__________________________________________________________________________________
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike.Blackwell@rrd.com
http://www.rrdonnelley.com

<http://www.rrdonnelley.com/&gt;
* <Mike.Blackwell@rrd.com>*

On Wed, Nov 9, 2011 at 16:02, Gauthier, Dave <dave.gauthier@intel.com>wrote:

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
ajs@crankycanuck.ca

If you are trying to kill one specific connection/backend, I'd
recommend using the pg_terminate_backend(pid_goes_here) function.

Robert Treat
conjecture: xzilla.net
consulting: omniti.com