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.
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
Ask me about our Expert PostgreSQL & PostGIS Training
In response to
pgsql-novice by date
|Next:||From: Mija Lee||Date: 2008-01-30 18:02:59|
|Subject: Re: pg_cancel_backend and pg_ctl kill|
|Previous:||From: Greg Cocks||Date: 2008-01-29 19:22:04|
|Subject: Re: Newbie just starting on charting with PHP - and seeking advice on options/approaches|