kill /KILL psql데몬프로세스넘버
혹은
kill /9 psql데몬프로세스넘버
를 실행하고..
/tmp 에 가셔서 쓰잘데기 없는거 다 지워주시면 되겠습니다.
특히 PGSQL 이라는 문구가 들어간넘!!!!
행복하세요~
>>August 님께서 쓰시길<<
:: 안녕하세요?
:: 이 게시판 덕에 Postgres를 잘 사용하고 있음다.
:: 근데, postgres를 재 가동 시킬려고
:: 먼저 아래와 같이 명령을 줬어여...
::
:: /usr/local/pgsql/bin/pg_ctl stop /D /data
::
:: 그리고 나서 웹페이지로 접속을 하니깐, shutdown 되었다고 메세지가 나오더군요.
::
:: Warning: Unable to connect to PostgreSQL server: The Data Base System is
:: shutting down in /usr/local/apache/htdocs/vaccin/include/dbi.inc on line 62
:: Error connecting to database
::
:: 근데, 다시 콘솔로 들어가서
:: ps /ef | grep pgsql
:: 명령으로 데몬을 확인해보니깐.... 그대로 떠 있는거예요....
:: 아래처럼...
::
:: postgres 17892 1 0 Jun05 ? 00:00:00 /usr/local/pgsql/bin/postmaster
:: postgres 17983 17892 0 00:08 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 17984 17892 0 00:08 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18196 17892 0 06:34 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18207 17892 0 07:16 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18333 17892 0 16:08 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18334 17892 0 16:08 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18359 17892 0 16:09 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18362 17892 0 16:13 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18363 17892 0 16:13 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18366 17892 0 16:15 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18399 17892 0 16:16 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18400 17892 0 16:16 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18403 17892 0 16:18 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18406 17892 0 16:19 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18407 17892 0 16:19 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18484 17892 0 16:37 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18519 17892 0 16:38 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18523 17892 0 16:44 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18524 17892 0 16:44 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18525 17892 0 16:49 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18526 17892 0 16:49 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18529 17892 0 16:50 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18530 17892 0 16:57 ? 00:00:00 /usr/local/pgsql/bin/postgres 21
:: postgres 18968 18831 0 18:42 pts/1 00:00:00 grep pgsql
::
::
:: 혹시나 해서 다시
:: /usr/local/pgsql/bin/postmaster /i /D /data
:: 명령을 줘봤는데.... 역시나
::
:: FATAL: StreamServerPort: bind() failed: Address already in use
:: Is another postmaster already running on that port?
:: If not, wait a few seconds and retry.
::
:: 이런 메세지가 나오더군요....
::
:: 그런데.... 지금 1시간 넘게 기다렸는데... 여전히 프로세서가 떠 있어여....
:: 제가 shutdown을 잘 못 시킨건가요?
:: 아님 더 기다려야 하나요? 더 기다려서 된다면, 원래 이렇게 오래 기다려야 하는건지....
::
:: 답변 좀 부탁드립니다......
::
::
::
|