PANIC: could not locate a valid checkpoint record

最新推荐文章于 2023-10-10 10:59:57 发布

行吟诗人

最新推荐文章于 2023-10-10 10:59:57 发布

阅读量860

点赞数

分类专栏： Linux开发 postgresql 文章标签：数据库 unix postgresql

本文链接：https://blog.csdn.net/qq331565760/article/details/126070924

版权

Linux开发同时被 2 个专栏收录

4 篇文章 0 订阅

订阅专栏

postgresql

1 篇文章 0 订阅

订阅专栏

 LOG:  listening on IPv6 address "::", port 5432
 LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
 LOG:  could not resolve "localhost": Name or service not known
 LOG:  disabling statistics collector for lack of working socket
 LOG:  database system was interrupted; last known up at 2022-07-29 17:43:18 CST
 LOG:  invalid primary checkpoint record
 PANIC:  could not locate a valid checkpoint record
 LOG:  startup process (PID 28908) was terminated by signal 6: Aborted
 LOG:  aborting startup due to startup process failure
 LOG:  database system is shut down
 LOG:  starting PostgreSQL 13.2 on x86_64-buildroot-linux-gnu, compiled by x86_64-tnas-linux-gnu-gcc.br_real (Buildroot 2017.11.2) 7.2.0, 64-bit
 LOG:  listening on IPv4 address "0.0.0.0", port 5432
 LOG:  listening on IPv6 address "::", port 5432
 LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
 LOG:  could not resolve "localhost": Name or service not known
 LOG:  disabling statistics collector for lack of working socket
 LOG:  database system was interrupted; last known up at 2022-07-29 17:43:18 CST
 LOG:  invalid primary checkpoint record
 PANIC:  could not locate a valid checkpoint record
 LOG:  startup process (PID 29066) was terminated by signal 6: Aborted
 LOG:  aborting startup due to startup process failure
 LOG:  database system is shut down

postgresql 报错

想要解决这个问题通常需要执行如下命令

su - postgres -c 'pg_resetwal /media/pgsql'

pg_resetwal 老版本可能不是这个命令

现在报错, 按照提示加上 -f

The database server was not shut down cleanly.
Resetting the write-ahead log might cause data to be lost.
If you want to proceed anyway, use -f to force reset.

su - postgres -f -c 'pg_resetwal /media/pgsql'