Hi All,
After setting up two nodes with MASTER and STANDBY replication, I see “ cp: cannot stat `/opt/postgres/9.1/archive/000000010000000000000003': No such file or directory” in the log on STANDBY and the startup process recovering “000000010000000000000004” which does not exist in the archive directory.
The replication is verified and works. My questions are what’s the reason causing “cp: cannot stat `/opt/postgres/9.1/archive/000000010000000000000003': No such file or directory” on STANDBY and how to fix it? Also, it seems the startup process stucks on “recovering 000000010000000000000004”, how to resolve it?
Thank you !
On STANDBY node:
LOG: entering standby mode
cp: cannot stat `/opt/postgres/9.1/archive/000000010000000000000003': No such file or directory
LOG: redo starts at 0/3000020
LOG: record with zero length at 0/30000B0
cp: cannot stat `/opt/postgres/9.1/archive/000000010000000000000003': No such file or directory
LOG: streaming replication successfully connected to primary
LOG: consistent recovery state reached at 0/4000000
LOG: database system is ready to accept read only connections
ls -rlt /opt/postgres/9.1/archive
-rw------- 1 postgres postgres 16777216 Oct 28 14:07 000000010000000000000001
-rw------- 1 postgres postgres 16777216 Nov 2 19:00 000000010000000000000002
ps -ef|grep startup|grep -v grep
postgres 9036 9020 0 19:00 ? 00:00:00 postgres: startup process recovering 000000010000000000000004
ps -ef|grep receiver|grep -v grep
postgres 9040 9020 0 19:00 ? 00:00:00 postgres: wal receiver process streaming 0/4000380
On MASTER node:
ls -rlt /opt/postgres/9.1/archive
-rw------- 1 postgres postgres 16777216 Oct 28 14:08 000000010000000000000001
-rw------- 1 postgres postgres 16777216 Nov 2 19:00 000000010000000000000002
-rw------- 1 postgres postgres 16777216 Nov 2 19:00 000000010000000000000003
-rw------- 1 postgres postgres 270 Nov 2 19:00 000000010000000000000003.00000020.backup
ps -ef|grep archiver |grep -v grep
postgres 9041 9035 0 18:57 ? 00:00:00 postgres: archiver process last was 000000010000000000000003.00000020.backup
ps -ef|grep sender |grep -v grep
postgres 9264 9035 0 19:00 ? 00:00:00 postgres: wal sender process postgres 192.168.154.106(64182) streaming 0/4000380
Cheers,
Joanna Xu
Senior Oracle DBA
Data Experience Solution BU
+1 613 595 5234
AMDOCS | EMBRACE CHALLENGE EXPERIENCE SUCCESS
POLICY CONTROL IN THE FAST LANE
What’s making policy control strategic in 2015 and beyond? Check out the top ten factors driving change…
This message and the information contained herein is proprietary and confidential and subject to the Amdocs policy statement, you may review at http://www.amdocs.com/email_disclaimer.asp