Kill Process ERROR !!!
От | aris wendy |
---|---|
Тема | Kill Process ERROR !!! |
Дата | |
Msg-id | E19a5PM-00054V-HO@out-mta1.plasa.com обсуждение исходный текст |
Ответы |
Re: Kill Process ERROR !!!
Re: Kill Process ERROR !!! Re: Kill Process ERROR !!! |
Список | 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
В списке pgsql-admin по дате отправления: