postgres数据库在电脑关机重启后,状态不一致导致无法启动
-
报错日志:
PostgreSQL Database directory appears to contain a database; Skipping initialization 2025-04-02 13:24:07.154 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2025-04-02 13:24:07.154 UTC [1] LOG: listening on IPv6 address "::", port 5432 2025-04-02 13:24:07.157 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2025-04-02 13:24:07.411 UTC [26] LOG: database system was shut down at 2025-04-02 11:47:48 UTC 2025-04-02 13:24:07.411 UTC [26] LOG: invalid record length at 8/DBE56CD8: wanted 24, got 0 2025-04-02 13:24:07.411 UTC [26] LOG: invalid primary checkpoint record 2025-04-02 13:24:07.411 UTC [26] LOG: invalid resource manager ID in secondary checkpoint record 2025-04-02 13:24:07.411 UTC [26] PANIC: could not locate a valid checkpoint record 2025-04-02 13:24:08.323 UTC [1] LOG: startup process (PID 26) was terminated by signal 6: Aborted 2025-04-02 13:24:08.323 UTC [1] LOG: aborting startup due to startup process failure 2025-04-02 13:24:08.338 UTC [1] LOG: database system is shut downpg_resetwal /var/lib/postgresql/data/pgdata