各位
目前我在测试pg_basebackup来做基础备份。发现备份经常不成功 。看pglog目录 显示如下
数据库版本:9.1.6
备份是连接 127.0.0.1直接备份
2013-09-22 04:30:01.780 CST,"gameop_bak","",28478,"127.0.0.1:40884",523e01c9.6f3e,1,"sending backup ""20130922""",2013-09-22 04:30:01 CST,49/0,0,LOG,08006,"could not send data to client: Connection reset by peer",,,,,,,,,"pg_basebackup"
2013-09-22 04:30:01.780 CST,"gameop_bak","",28478,"127.0.0.1:40884",523e01c9.6f3e,2,"sending backup ""20130922""",2013-09-22 04:30:01 CST,49/0,0,FATAL,XX000,"base backup could not send data, aborting backup",,,,,,,,,"pg_basebackup"
2013-09-22 04:30:01.781 CST,"gameop_bak","",28478,"127.0.0.1:40884",523e01c9.6f3e,3,"sending backup ""20130922""",2013-09-22 04:30:01 CST,49/0,0,LOG,08006,"could not send data to client: Broken pipe",,,,,,,,,"pg_basebackup"
2013-09-22 17:25:01.386 CST,"gameop_bak","",23241,"127.0.0.1:34349",523eb76d.5ac9,1,"sending backup ""20130922""",2013-09-22 17:25:01 CST,49/0,0,LOG,08006,"could not send data to client: Connection reset by peer",,,,,,,,,"pg_basebackup"
2013-09-22 17:25:01.386 CST,"gameop_bak","",23241,"127.0.0.1:34349",523eb76d.5ac9,2,"sending backup ""20130922""",2013-09-22 17:25:01 CST,49/0,0,FATAL,XX000,"base backup could not send data, aborting backup",,,,,,,,,"pg_basebackup"
2013-09-22 17:25:01.387 CST,"gameop_bak","",23241,"127.0.0.1:34349",523eb76d.5ac9,3,"sending backup ""20130922""",2013-09-22 17:25:01 CST,49/0,0,LOG,08006,"could not send data to client: Broken pipe",,,,,,,,,"pg_basebackup"
不知有没有人碰到类似的问题。有没有解决方法 |