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