Troubleshooting postgresql replication issues

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


The Bahmni documentation is licensed under Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)