[postgresql] PANIC: could not locate a valid checkpoint record

갑자기 잘 접속되던 postgresql이 접속이 안되는 상황. (버전은 14)

 

configuration 파일들은 전부 잘 설정 된 상황 (이전까지 잘 썼으니)

 

/var/log/postgresql 경로에서 postgresql-14-main.log 파일을 확인 

 

systemctl restart postgresql 명령어 입력 시 아래와 같은 에러 메세지 생성

2023-02-26 21:49:14.327 PST [14961] LOG:  starting PostgreSQL 14.7 (Ubuntu 14.7-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
2023-02-26 21:49:14.327 PST [14961] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2023-02-26 21:49:14.327 PST [14961] LOG:  listening on IPv6 address "::", port 5432
2023-02-26 21:49:14.328 PST [14961] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2023-02-26 21:49:14.331 PST [14967] LOG:  database system was interrupted; last known up at 2023-02-26 16:18:20 PST
2023-02-26 21:49:14.341 PST [14967] LOG:  invalid primary checkpoint record
2023-02-26 21:49:14.341 PST [14967] PANIC:  could not locate a valid checkpoint record
2023-02-26 21:49:14.451 PST [14961] LOG:  startup process (PID 14967) was terminated by signal 6: Aborted
2023-02-26 21:49:14.451 PST [14961] LOG:  aborting startup due to startup process failure
2023-02-26 21:49:14.453 PST [14961] LOG:  database system is shut down
pg_ctl: could not start server
Examine the log output.

예상 원인 : 트랜잭션 로그 꼬임

 

해결법

# 아래 경로로 이동
/usr/lib/postgresql/14/bin

# 명령어 입력
./pg_resetwal -f /var/lib/postgresql/14/main

주의사항

데이터 소실이 있을 수 있음

 

결과

DB 연결이 잘 된다!