pgsql | 2020-01-18 16:14:06.418 CST [25] LOG: invalid primary checkpoint record
pgsql | 2020-01-18 16:14:06.418 CST [25] PANIC: could not locate a valid checkpoint record
如果在容器中, 使用
docker run -it -v /dbdata/postgresql:/var/lib/postgresql/data registry.uixe.net/images/postgres /bin/bash
registry.uixe.net/images/postgres 是我的内网镜像地址
使用su 切换至postgres用户便于执行 pg_resetwal
su postgres
pg_resetwal -f /var/lib/postgresql/data
如果遇到 pg_resetwal: error: lock file "postmaster.pid" exists
pg_resetwal: Is a server running? If not, delete the lock file and try again
删除
rm /var/lib/postgresql/data/postmaster.pid
再执行
pg_resetwal -f /var/lib/postgresql/data