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 has an

[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

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 46708

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: postgres

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

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