Обсуждение: SIGNALNAME in "pg_ctl kill"
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.
Thanks for any insights !
__________________________________________________________________________________
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
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.
Thanks for any insights !
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 On Wed, Nov 9, 2011 at 5:18 PM, Mike Blackwell <mike.blackwell@rrd.com> wrote: > 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 > > > > On Wed, Nov 9, 2011 at 16:02, Gauthier, Dave <dave.gauthier@intel.com> > 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. >> >> >> >> Thanks for any insights ! >
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