暗能星系

    • 登录
    • 搜索

    postgres数据库在电脑关机重启后,状态不一致导致无法启动

    问题记录及解决
    1
    1
    8
    正在加载更多帖子
    • 从旧到新
    • 从新到旧
    • 最多赞同
    回复
    • 在新帖中回复
    登录后回复
    此主题已被删除。只有拥有主题管理权限的用户可以查看。
    • Z
      zhanglu 最后由 编辑

      报错日志:

      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 down
      

      解决措施:
      https://stackoverflow.com/questions/71258094/invalid-resource-manager-id-in-primary-checkpoint-record

      pg_resetwal /var/lib/postgresql/data/pgdata
      
      1 条回复 最后回复 回复 引用 0
      • First post
        Last post
      Powered by 暗能星系