postgresql PSQL时间轴冲突阻止启动主控形状

hl0ma9xz  于 2023-02-04  发布在  PostgreSQL
关注(0)|答案(1)|浏览(145)

我们的一个PSQL 14(由Zalando管理)出现中断,原因是30分钟内无法访问k8s控制平面。控制平面现在正常,但主PSQL不想启动:

LOG,00000,"listening on IPv4 address ""0.0.0.0"", port 5432"
LOG,00000,"listening on IPv6 address ""::"", port 5432"
LOG,00000,"listening on Unix socket ""/var/run/postgresql/.s.PGSQL.5432"""
LOG,00000,"database system was shut down at 2023-01-30 02:51:10 UTC"
WARNING,01000,"specified neither primary_conninfo nor restore_command",,"The database server will regularly poll the pg_wal subdirectory to check for files placed there."
LOG,00000,"entering standby mode"
FATAL,XX000,"requested timeline 5 is not a child of this server's history","Latest checkpoint is at 2/82000028 on timeline 4, but in the history of the requested timeline, the server forked off from that timeline at 0/530000A0."
LOG,00000,"startup process (PID 23007) exited with exit code 1"
LOG,00000,"aborting startup due to startup process failure"
LOG,00000,"database system is shut down"

我们可以在archive_status文件夹中看到:

-rw-------. 1 postgres postgres 0 Jan 30 02:51 000000040000000200000081.ready
-rw-------. 1 postgres postgres 0 Jan 30 02:51 00000005.history.done

您知道我们如何才能安全地从这种情况中恢复吗?我想切换回时间轴4就足够了,因为时间线5是在大修开始后制定的。

bxgwgixi

bxgwgixi1#

服务器已在待机模式下启动。如果要将服务器作为主服务器启动,请删除standby.signal

相关问题