Amazon-Ec2

本機 Postgresql 9.2 流複製

  • February 6, 2013

我正在嘗試在亞馬遜雲中建立原生 postgresql 9.2 流複製。

根據文件,我已經正確設置了所有內容 - 但是在從站我得到了這些日誌:

2013-02-04 13:18:01.315 GMT LOG:  streaming replication successfully connected to primary
2013-02-04 13:23:07.109 GMT LOG:  invalid record length at 0/10000080
2013-02-04 13:23:07.109 GMT FATAL:  terminating walreceiver process due to administrator command
2013-02-04 13:23:07.209 GMT LOG:  invalid record length at 0/10000080
2013-02-04 13:23:12.214 GMT LOG:  invalid record length at 0/10000080
2013-02-04 13:23:17.219 GMT LOG:  invalid record length at 0/10000080
2013-02-04 13:23:22.225 GMT LOG:  invalid record length at 0/10000080
2013-02-04 13:23:27.230 GMT LOG:  invalid record length at 0/10000080
2013-02-04 13:23:32.235 GMT LOG:  invalid record length at 0/10000080
2013-02-04 13:23:37.240 GMT LOG:  invalid record length at 0/10000080
2013-02-04 13:23:42.245 GMT LOG:  invalid record length at 0/10000080
2013-02-04 13:23:47.251 GMT LOG:  invalid record length at 0/10000080

當我將數據插入主控時,這開始了。任何想法可能是什麼問題?

我已經解決了這個問題。訣竅是,不要在沒有 recovery.conf 文件的情況下啟動數據庫。Postgresql 會做一些破壞複製的事情,即使對數據庫沒有進行明顯的更改。

引用自:https://serverfault.com/questions/475199