By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,967 Members | 2,124 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,967 IT Pros & Developers. It's quick & easy.

Recovery using continuous archiving

P: 4
I have enabled streaming replication between two server say master and slave. Now after this I enabled archiving changing following parameters-

On the master node, configure "postgresql.conf"

archive_mode = on
archive_command = 'cp %p /u01/arch/%f'
archive_timeout = 120
max_wal_senders = 5
wal_keep_segments = 10

After this I edited the recovery.conf file on the slave server-

modify "recovery.conf" on the standby node

trigger_file = '/tmp/pg_failover.trigger'
restore_command = 'cp /u01/arch/%f %p'

Now due to server load the slave WAL receiver lags behind and the WAL needed by slave has been archived and removed from the pg_xlog.

Issue is that the following error is generated on slave-
cp: cannot stat `/u01/arch/0000000100000005000000C5': No such file or directory
2013-09-18 16:02:38 IST LOG: streaming replication successfully connected to primary
2013-09-18 16:02:38 IST FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000005000000C4 has already been removed

Please help me to resolve this.

Thanks in advance.
Sep 19 '13 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.