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 restored a master database after a fallback by creating a new basebackup and making the promoted slave stand_by again. Per the logs everything is fine, however the following functions are not matching:

On master:

SELECT pg_current_xlog_location();

pg_current_xlog_location 
--------------------------
0/31000078
(1 row)

On slave:

select pg_last_xlog_receive_location();

pg_last_xlog_receive_location 
-------------------------------
0/31000078

(1 row)

select pg_last_xlog_replay_location();

pg_last_xlog_replay_location 
------------------------------
0/31000020
(1 row)

The receive location is OK, but the replay is not... resulting in out to date data. Now I waited the whole night just in case... and even restarted slave several time, but it's not caching up. Is there a way or command I can execute to perform the pending transactions.

Thanks a lot

share|improve this question
    
What's in the log files on the replica? –  Craig Ringer Mar 14 at 23:21
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.