我正在亚马逊云中构建本地PostgreSQL9.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当我将数据插入主服务器时,这就开始了。有什么问题吗?
发布于 2013-02-06 13:37:50
我已经解决了问题。诀窍是,不要在没有recovery.conf文件的情况下启动数据库。Postgresql执行一些中断复制的操作,即使没有对数据库进行明显的更改。
https://serverfault.com/questions/475199
复制相似问题