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
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?