Questions on Post Setup MASTER and STANDBY replication - Postgres9.1

[Joanna Xu <Joanna.Xu@xxxxxxxxxx>]

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