Take the 2-minute tour ×
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.

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

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

share|improve this question

migrated from stackoverflow.com Feb 24 '13 at 8:59

This question came from our site for professional and enthusiast programmers.

add comment

1 Answer 1

It sounds like PostgreSQL is set to recover from log shipping rather than by connecting as a replication user. Please double and triple check your recovery.conf and if that doesn't work, then post it here.

The approach you are taking is a valid approach though, and it means that the recovery will just wait for the next segment until it arrives creating the message you are seeing, but it must be transferred using whatever recovery command you have configured in the master's postgresql.conf.

share|improve this answer
add comment

Your Answer

 
discard

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