Skip site navigation (1) Skip section navigation (2)

Re: pg_cancel_backend and pg_ctl kill

From: Chander Ganesan <chander(at)otg-nc(dot)com>
To: Mija Lee <mija(at)scharp(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_cancel_backend and pg_ctl kill
Date: 2008-01-30 03:48:34
Message-ID: 479FF392.3090308@otg-nc.com (view raw or flat)
Thread:
Lists: pgsql-novice
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


In response to

Responses

pgsql-novice by date

Next:From: Mija LeeDate: 2008-01-30 18:02:59
Subject: Re: pg_cancel_backend and pg_ctl kill
Previous:From: Greg CocksDate: 2008-01-29 19:22:04
Subject: Re: Newbie just starting on charting with PHP - and seeking advice on options/approaches

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group