Versions Compared
compared with
Key
- This line was added.
- This line was removed.
- Formatting was changed.
This document will help you understand how you can troubleshoot issues pertaining to postgresql replication.
Check if postgresql replication is running
Code Block ps -ef | grep sender ps -ef | grep receiver
Check replication replay on slave
Code Block 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)
Code Block sudo service postgresql-9.2 restart