Hello all,
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...
http://www.postgresql.org/docs/8.3/i...archiving.html
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....
Thoughts/Suggestions/Questions?
Thanks,
-C