PostgreSQL Processes on a linux box

From: Stefan Sturm <stefan(dot)s(dot)sturm(at)googlemail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL Processes on a linux box
Date: 2008-04-11 13:09:43
Message-ID: EFC68E2C-DA60-4BB4-BBAF-1E273EB3DB53@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Thanks and greetings,
Stefan Sturm

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Glyn Astill 2008-04-11 13:59:56 createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8
Previous Message Craig Ringer 2008-04-11 12:54:37 Re: Postgres on shared network drive