Re: [GENERAL] PostgreSQL Processes on a linux box

2008-04-12 Thread Ray Stell
On Fri, Apr 11, 2008 at 04:48:03PM -0500, Erik Jones wrote: > On Apr 11, 2008, at 4:23 PM, Stefan Sturm wrote: >> 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? > > There is a system catalog view called pg_locks that ha

Re: [GENERAL] PostgreSQL Processes on a linux box

2008-04-11 Thread Erik Jones
On Apr 11, 2008, at 4:23 PM, Stefan Sturm wrote: 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:

Re: [GENERAL] PostgreSQL Processes on a linux box

2008-04-11 Thread Stefan Sturm
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

Re: [GENERAL] PostgreSQL Processes on a linux box

2008-04-11 Thread Scott Marlowe
On Fri, Apr 11, 2008 at 7:09 AM, Stefan Sturm <[EMAIL PROTECTED]> wrote: > Hello, > > altered a database using DBVisualizer. When I hit execute, 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: > p

Re: [GENERAL] PostgreSQL Processes on a linux box

2008-04-11 Thread 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 46

[GENERAL] PostgreSQL Processes on a linux box

2008-04-11 Thread Stefan Sturm
Hello, altered a database using DBVisualizer. When I hit execute, 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 46