PostgreSQL 启动失败

20次阅读

共计 1027 个字符,预计需要花费 3 分钟才能阅读完成。

PostgreSQL 启动失败,报错和下面类似

2022-05-29 21:52:22.926 CST [35270] LOG: starting PostgreSQL 14.3 on x86_64-pc-linux-gnu,
compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit
2022-05-29 21:52:22.927 CST [35270] LOG: listening on IPv6 address “::1”, port 5432
2022-05-29 21:52:22.927 CST [35270] LOG: listening on IPv4 address “127.0.0.1”, port 5432
2022-05-29 21:52:22.929 CST [35270] LOG: listening on Unix socket “/var/run/postgresql/.s.PGSQL.5432”
2022-05-29 21:52:22.931 CST [35270] LOG: listening on Unix socket “/tmp/.s.PGSQL.5432”
2022-05-29 21:52:22.936 CST [35272] LOG: database system was interrupted; last known up at 2022-05-28 21:36:11 CST
2022-05-29 21:52:23.049 CST [35272] LOG: invalid primary checkpoint record
2022-05-29 21:52:23.049 CST [35272] PANIC: could not locate a valid checkpoint record
2022-05-29 21:52:24.211 CST [35270] LOG: startup process (PID 35272) was terminated by signal 6: Aborted
2022-05-29 21:52:24.211 CST [35270] LOG: aborting startup due to startup process failure
2022-05-29 21:52:24.218 CST [35270] LOG: database system is shut down

根据网上查询的到信息,“重设 wal”即可解决”,但这样操作可能会丢失数据,想知道如何判断大概会丢失哪些数据,因为是生产环境,需要评估一下,垦求各位发表自己的看法,不胜感激。

正文完
 0