Re: PostgreSQL Processes on a linux box

Hello,

Am 11.04.2008 um 18:41 schrieb Andrew Sullivan:

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

I don''t want to kill them. So how can I find out, what ist locking
them?
Is there a tool, which shows me such Information?

Thanks,
Stefan Sturm