안녕하세요?
이 게시판 덕에 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을 잘 못 시킨건가요?
아님 더 기다려야 하나요? 더 기다려서 된다면, 원래 이렇게 오래 기다려야 하는건지....
답변 좀 부탁드립니다......
|