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@xxxxxxx> 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@xxxxxxx > http://www.rrdonnelley.com > > > > On Wed, Nov 9, 2011 at 16:02, Gauthier, Dave <dave.gauthier@xxxxxxxxx> > 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 ! > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
