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