Re: SIGNALNAME in "pg_ctl kill"

From: Robert Treat <rob(at)xzilla(dot)net>
To: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
Cc: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: SIGNALNAME in "pg_ctl kill"
Date: 2011-11-09 22:26:50
Message-ID: CABV9wwMgH9u3ow31Ew0wTLcDNDLMJH8veROV2Y0yG-+9vkK=+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)blackwell(at)rrd(dot)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(dot)Blackwell(at)rrd(dot)com
> http://www.rrdonnelley.com
>
>
>
> On Wed, Nov 9, 2011 at 16:02, Gauthier, Dave <dave(dot)gauthier(at)intel(dot)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 !
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Keegan,Nate 2011-11-09 23:00:02 PostgreSQL 9.0.5 concat Issue
Previous Message Andrew Sullivan 2011-11-09 22:22:06 Re: SIGNALNAME in "pg_ctl kill"