Re: [GENERAL] SIGNALNAME in "pg_ctl kill"

2011-11-09 Thread Andrew Sullivan
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 th

Re: [GENERAL] SIGNALNAME in "pg_ctl kill"

2011-11-09 Thread Robert Treat
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 wrote: > The manual section on the postmaster process has som

Re: [GENERAL] SIGNALNAME in "pg_ctl kill"

2011-11-09 Thread Mike Blackwell
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 Donnell

[GENERAL] SIGNALNAME in "pg_ctl kill"

2011-11-09 Thread Gauthier, Dave
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 t