Re: PostgreSQL Processes on a linux box - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: PostgreSQL Processes on a linux box
Date
Msg-id 20080411164130.GB28760@crankycanuck.ca
Whole thread Raw
In response to PostgreSQL Processes on a linux box  (Stefan Sturm <stefan.s.sturm@googlemail.com>)
Responses Re: PostgreSQL Processes on a linux box  (Stefan Sturm <stefan.s.sturm@googlemail.com>)
List pgsql-general
On Fri, Apr 11, 2008 at 03:09:43PM +0200, Stefan Sturm wrote:
> DBVisualizer stoped working and no I have two processes on my server:
> postgres 30873  0.0  0.7  46552  7124 ?        Ss   12:33   0:01
> postgres: postgres dbName 10.0.1.198(53658) ALTER TABLE waiting
> postgres 31007  0.0  0.6  46708  6500 ?        Ss   13:07   0:00
> postgres: postgres dbName 10.0.1.198(53799) SELECT waiting
>
> What can I do? OK, I can stop and start the Database, but I think
> there are other ways to handle this...
> What Tool can I use to kill such processes?

Why do you want to kill them?  They're waiting for a lock.  What is it?

A


pgsql-general by date:

Previous
From: Reece Hart
Date:
Subject: tsearch2 and hyphenated terms
Next
From: "Scott Marlowe"
Date:
Subject: Re: PostgreSQL Processes on a linux box