이번에 이런메세지도 나오는데요...
FATAL 1: cannot open /usr/local/pgsql/data/PG_VERSION: Too
many open files in system
FATAL 1: cannot open /usr/local/pgsql/data/PG_VERSION: Too many open files in s
ystem
FATAL 1: cannot open /usr/local/pgsql/data/PG_VERSION: Too many open files in s
ystem
FATAL 1: cannot open pg_log: Too many open files in system
find_hba_entry: Unable to open authentication config file "/usr/local/pgsql/data
/pg_hba.conf": Too many open files in system
Missing or erroneous pg_hba.conf file, see postmaster log for details
postmaster: StreamConnection: accept: Too many open files in system
find_hba_entry: Unable to open authentication config file "/usr/local/pgsql/data
/pg_hba.conf": Too many open files in system
Missing or erroneous pg_hba.conf file, see postmaster log for details
postmaster: StreamConnection: accept: Too many open files in system
find_hba_entry: Unable to open authentication config file "/usr/local/pgsql/data
/pg_hba.conf": Too many open files in system
Missing or erroneous pg_hba.conf file, see postmaster log for details
postmaster: StreamConnection: accept: Too many open files in system
postmaster: StreamConnection: accept: Too many open files in system
postmaster: StreamConnection: accept: Too many open files in system
postmaster: StreamConnection: accept: Too many open files in system
postmaster: StreamConnection: accept: Too many open files in system
>>정재익 님께서 쓰시길<<
:: 현재 말씀하신 것만으로는 속도가 왜 그렇게 느린지 알수가 없습니다. 단지 아래에 나오는 DEBUG 메시
:: 지는 컴파일시 디버깅 메시지가 나오도록 옵션이 주어졌기 때문으로 생각되며, 그 자체는 크게 나쁠것
:: 이 없다고 생각합니다.
::
:: >>여준성 님께서 쓰시길<<
::
:: :: postgres를 시작한지 얼마되지 않는데 속도가 굉장히 느립니다.
:: :: 그리고 재시작을 하면 다음과 같은 메세지가 꼭 떠오릅니다.
:: ::
:: :: 시작은 pg_ctl -o '-N 512 -B 1024 -i' -D /usr/local/pgsql/data start
:: :: 했습니다.
:: ::
:: :: 아시는 분은 가르쳐 주세요....
:: :: 그리고 속도는 원래 그렇게 느린가요? 한 10분 기다려야 되는 것 같아요....
:: ::
:: ::
:: :: DEBUG: database system was shut down at 2001-06-25 15:43:17 KST
:: :: DEBUG: CheckPoint record at (0, 611514528)
:: :: DEBUG: Redo record at (0, 611514528); Undo record at (0, 0); Shutdown TRUE
:: :: DEBUG: NextTransactionId: 1502188; NextOid: 61561
:: :: DEBUG: database system is in production state
:: ::
|