설문조사
PostgreSQL/PPAS 관련 듣고 싶은 교육은


총 게시물 187건, 최근 0 건
   

서버에 시스템 작동중 Postgresql 서비스가 종료되는 현상

글쓴이 : incheols2929 날짜 : 2017-10-10 (화) 11:13 조회 : 7475
postgresql을 사용하여 실서버에  시스템을 설치하였습니다. postgresql9.2버전과 postgis2.0버전을 사용하고 있는데요. 한번씩 postgresql가 종료되는 현상이 발생하고 있습니다.
로그가 찍힌 현황입니다. 도움 부탁드립니다..
2017-10-10 01:10:43 BST LOG: database system was interruped; last known up at 2017-10-01 19:35:16 BST
2017-10-10 01:10:43 BST FATAL: the database system is starting up
2017-10-10 01:10:43 BST FATAL: the database system is starting up
2017-10-10 01:10:43 BST LOG: database systtem was not properly shut down; automatic recovery in progress
2017-10-10 01:10:43 BST FATAL: the database system is starting up
2017-10-10 01:10:43 BST LOG: redo starts at 3C/3A37F478
2017-10-10 01:10:43 BST LOG: unexpected pageaddr 3C/33ADA000 in log file 60, segment 59, offset 11378688
2017-10-10 01:10:43 BST LOG: last completed transaction was at log time 2017-10-01 19:35:20.916+01
2017-10-10 01:10:43 BST FATAL: the database system is starting up
2017-10-10 01:10:43 BST FATAL: the database system is starting up
2017-10-10 01:10:43 BST LOG: database system is ready to accept connections
2017-10-10 01:10:43 BST LOG: autovacuum launcher started

주킹 2017-10-10 (화) 16:54
저부분은 system log를 보시던가...
지속적인 모니터링 및 log level을 올리셔서 바야합니다.
장애에 대한 세부적인 부분은 PostgreSQL 지원 업체를 통해 지원을 받으셔야겠죠..
댓글주소
   

postgresdba.com