Kill Process ERROR !!!

From: aris wendy <aris_postgre(at)telkom(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Kill Process ERROR !!!
Date: 2003-07-09 09:52:38
Message-ID: E19a5PM-00054V-HO@out-mta1.plasa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear master

How to kill a process in postgresql. I use ps auxw | grep postgres to see
status....

it-linux:/usr/local/pgsql/data# ps auxw | grep postgres
postgres 197 0.0 7.1 318528 64244 ? S 08:07 0:00
/usr/local/pgsql/bin/postmaster
postgres 206 0.0 0.1 319484 1244 ? S 08:07 0:00 postgres:
stats buffer process
postgres 207 0.0 6.1 318516 55580 ? S 08:07 0:00 postgres:
stats collector process
yudha 571 0.0 0.1 2448 1068 pts/0 S 09:56 0:00 psql
-Upostgres csa
postgres 572 0.0 8.8 319940 79208 ? S 09:56 0:00 postgres:
postgres csa [local] idle
postgres 582 0.5 9.6 320284 86968 ? S 10:02 0:00 postgres: it
csa 192.168.0.234 idle
postgres 587 1.1 10.4 320972 93636 ? S 10:04 0:00 postgres:
postgres csa 192.168.0.111 idle
postgres 588 14.6 10.0 320536 90448 ? S 10:04 0:01 postgres:
postgres csa 192.168.0.100 idle
postgres 589 2.0 7.3 318844 66232 ? S 10:05 0:00 postgres:
checkpoint subprocess
postgres 590 0.0 7.9 320020 71592 ? R 10:05 0:00 postgres:
postgres csa 192.168.0.222 SELECT
root 592 0.0 0.0 1332 424 pts/1 S 10:05 0:00 grep postgres

I want to kill process no 582, I use kill -9 582 but all user become
disconnect look at below

it-linux:/usr/local/pgsql/data# ps auxw | grep postgres
postgres 197 0.0 7.1 318564 64264 ? S 08:07 0:00
/usr/local/pgsql/bin/postmaster
postgres 206 0.0 0.1 319484 1244 ? S 08:07 0:00 postgres:
stats buffer process
postgres 207 0.0 6.1 318516 55580 ? S 08:07 0:00 postgres:
stats collector process
yudha 571 0.0 0.1 2448 1068 pts/0 S 09:56 0:00 psql
-Upostgres csa
root 599 0.0 0.0 1332 424 pts/1 S 10:06 0:00 grep postgres

how to kill only one process ?

TIA

Best Regards
Aris Wendy

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Donald Fraser 2003-07-09 10:03:56 Re: Overloading functions that are used by operators.
Previous Message Andrea Suisani 2003-07-09 08:56:56 Re: Kill Process ERROR !!!