This document will help you understand how you can troubleshoot issues pertaining to postgresql replication.

 

  • Check if postgresql replication is running

    ps -ef | grep sender
    ps -ef | grep receiver
  • Check replication replay on slave

    select pg_last_xlog_receive_location();
    select pg_last_xlog_replay_location();
  • Restart replication on slave if needed (you do this by restarting postgresql on slave)

    sudo service postgresql-9.2 restart