On Wed, Jul 04, 2012 at 10:43:19PM +0000, Jim Busser wrote:
> >> I have a mirrored slave server that is replicating in real time On Site using R-sync.
> >> I also have a back-up offsite storage that receives a copy of the entire database nightly.
> >> I have Sentinel programs in place to make sure each of these back-ups are operational.
> >> A script running on the "Slave" server that executes once an hour, and checks the master/slave replication status. It's actually fairly smart, it connects to the master DB (from the slave server), asks for the master status, which gives it the binary logfile name and the logfile position.
> >> It then does a "show slave status" on the slave, and compares. If the numbers don't match, it sends an email to me.
> >> I also receive a daily email form my remote back-up server indicating the size of yesterday's back up file as well as the size of today's back up file.
> For some of the above, would 'check_postgres' be suitable?