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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

pg_cancel_backend and pg_ctl kill


  • From: Mija Lee <mija(at)scharp(dot)org>
  • To: pgsql-novice(at)postgresql(dot)org
  • Subject: pg_cancel_backend and pg_ctl kill
  • Date: Fri, 25 Jan 2008 09:57:16 -0800
  • Message-id: <479A22FC.5070402@scharp.org> <text/plain>

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...

Running 8.2.4 on solaris 10.

Mija








Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group