-   Linux - Server (
-   -   Postgresql Warm standby problem - WAL didn't replay... (

custangro 06-25-2008 03:18 PM

Postgresql Warm standby problem - WAL didn't replay...
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...

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




custangro 06-26-2008 11:22 AM

Hello all,

After digging through the logs I found out my problem...I appearers that the transaction ID wasn't the same.

To solve it; I make a "hot backup" following this

Then I tar-ed up the data directory as described here...

Then I moved the tar-ed datadir and scp-ed it over to the standby database server and untar-ed the tar-ed file in the appropriate location and statred up postgres in "standby mode (continuous recovery)" and I tested the failover mechanism and the database was up to date...

Hope this helps!


Tinkster 06-27-2008 05:03 PM

Congratulations on resolving the issue, and thanks for
updating the thread with the resolution.


All times are GMT -5. The time now is 12:20 PM.