We have been trying to implement the streaming replication on one of our test servers. We have set archive_xlogs to on. But on the standby server, when we start the database we get error the following errors:
LOG: shutting down LOG: database system is shut down LOG: database system was shut down in recovery at 2010-10-05 05:05:27 EDT LOG: entering standby mode cp: cannot stat `/home/postgres/archive_xlogs/000000010000000D00000036': No such file or directory LOG: consistent recovery state reached at D/36000078 LOG: database system is ready to accept read only connections LOG: invalid record length at D/36000078 cp: cannot stat `/home/postgres/archive_xlogs/000000010000000D00000036': No such file or directory LOG: streaming replication successfully connected to primary
The file "000000010000000D00000036" is seen in pg_xlog folder of the primary database, but is not yet pushed to the archive location.
Can you let us know what the error means and if we are doing anything wrong?
