开发者社区> 问答> 正文

Postgres 主从切换 record with incorrect prev-link

数据库主从切换 PG9.6

环境
A 主 B 从

Step 1
B升级为主  pg_ctl promote -D .
B现在可读可写,timeline +1

Step 2
A变为从 pg_rewind 对齐timeline
修改recovery.done -> recover.conf 及内容
结果
主从切换成功

悲催 在Step2 中没有关闭A

< 2017-09-30 10:18:22.018 CST > LOG: record with incorrect prev-link EB000000/87 at 0/BE04AFE0
< 2017-09-30 10:18:27.024 CST > LOG: record with incorrect prev-link EB000000/87 at 0/BE04AFE0
< 2017-09-30 10:18:32.029 CST > LOG: record with incorrect prev-link EB000000/87 at 0/BE04AFE0
< 2017-09-30 10:18:37.034 CST > LOG: record with incorrect prev-link EB000000/87 at 0/BE04AFE0
< 2017-09-30 10:18:42.040 CST > LOG: record with incorrect prev-link EB000000/87 at 0/BE04AFE0
< 2017-09-30 10:18:47.045 CST > LOG: record with incorrect prev-link EB000000/87 at 0/BE04AFE0
< 2017-09-30 10:18:52.050 CST > LOG: record with incorrect prev-link EB000000/87 at 0/BE04AFE0
< 2017-09-30 10:18:57.056 CST > LOG: record with incorrect prev-link EB000000/87 at 0/BE04AFE0

启动失败,该怎么解决。

展开
收起
eamon13 2017-09-30 10:46:12 6964 0
0 条回答
写回答
取消 提交回答
问答分类:
问答地址:
问答排行榜
最热
最新

相关电子书

更多
AliHB Real-Time Cold data Backup 立即下载
AliHB Real Time Cold data Backup 立即下载
Borgaonkar-New-Adventures-In-Spying-3G-And-4G-Users-Locate-Track-And-Monitor 立即下载