Re: pg_cancel_backend and pg_ctl kill

[Mija Lee <mija(at)scharp(dot)org>]

Thanks Chander. I will just use the kill then.

Chander Ganesan wrote:
> Hi Mija,
>
> Mija Lee wrote:
> > Hi -
> >
> > I've been having some problems where we have a nightly script to
> > replicate data which fails because of an <IDLE in transaction> process.
> > I figured I should kill any of the processes before doing the
> > replication. I've read several of the posts about pg_cancel_backend 
> > and from what I've read it looks like this won't kill IDLE processes. 
> > There were several suggestions about shelling out & using kill, or 
> > writing a C function.
> >
> > What I'm wondering about is if pg_ctl kill [procpid] will do the job. 
> > The doc seems to suggest this, but I'm wanted to check before bringing 
> > my server to it's knees...
> It will, but it's about the same as killing the backend process using 
> the 'kill' command.  It's especially useful in the Windows environment, 
> where no kill command exists.
>
> --
> Chander Ganesan
> Open Technology Group, Inc.
> One Copley Parkway, Suite 210
> Morrisville, NC  27560
> Phone: 877-258-8987/919-463-0999
> http://www.otg-nc.com
> Ask me about our Expert PostgreSQL & PostGIS Training