测试开发技术网站

# 问题描述
当Postgres数据库所在的服务器在重启后，Postgres起不来，报如下错误
```bash
2024-12-02 10:58:08 CST [1]: [1-1] user=,db= LOG:  starting PostgreSQL 16.6 (Debian 16.6-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-12-02 10:58:08 CST [1]: [2-1] user=,db= LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-12-02 10:58:08 CST [1]: [3-1] user=,db= LOG:  listening on IPv6 address "::", port 5432
2024-12-02 10:58:08 CST [1]: [4-1] user=,db= LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-12-02 10:58:08 CST [9]: [1-1] user=,db= LOG:  database system was shut down at 2024-11-29 16:05:20 CST
2024-12-02 10:58:08 CST [9]: [2-1] user=,db= LOG:  invalid magic number 0000 in WAL segment 0000000100000010000000E8, LSN 10/E8000000, offset 0
2024-12-02 10:58:08 CST [9]: [3-1] user=,db= LOG:  invalid checkpoint record
2024-12-02 10:58:08 CST [9]: [4-1] user=,db= PANIC:  could not locate a valid checkpoint record
2024-12-02 10:58:22 CST [1]: [5-1] user=,db= LOG:  startup process (PID 9) was terminated by signal 6: Aborted
2024-12-02 10:58:22 CST [1]: [6-1] user=,db= LOG:  aborting startup due to startup process failure
2024-12-02 10:58:23 CST [1]: [7-1] user=,db= LOG:  database system is shut down

```

# 解决办法
使用 pg_resetwal -D /path/to/data/directory 命令可恢复，具体如果是基于k8s部

测试开发技术网站

博客