Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I have two PostgreSQL servers running on my local Ubuntu machine (port 5437 is master, port 5438 is standby).

When I followed the tutorial on

http://wiki.postgresql.org/wiki/Hot_Standby

I get this in my log2:

LOG:  database system was interrupted; last known up at 2013-02-23 20:48:03 PST
LOG:  creating missing WAL directory "pg_xlog/archive_status"
LOG:  entering standby mode
LOG:  restored log file "000000010000000000000002" from archive
LOG:  redo starts at 0/2000020
LOG:  consistent recovery state reached at 0/20000C4
LOG:  database system is ready to accept read only connections
cp: cannot stat `/home/ga/p1/000000010000000000000003': No such file or directory
cp: cannot stat `/home/ga/p1/000000010000000000000003': No such file or directory

and the last line repeats indefinitely...

The file is missing. With WAL, when would the new file be created?

Thanks,

share|improve this question

migrated from stackoverflow.com Feb 24 at 8:59

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.