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