I have installed postgres on two machines. Both are similar machines and both are running postgresql 8.3.3.
I set up one in archive mode and the other in recovery mode and have set up the copying the WAL archive "push" to the other machine as described here...
I did a test and added a table with some entries...waited about an hour...made sure the WAL archives got pushed over to the other server; then I stopped the primary. I then brought up the warm standby and I waited until the recovery.conf
file changed to recovery.done
I logged into the database and the table wasn't there
I seems that the WAL didn't replay...The database was only as recent as the last pg_dump....