Re: [Gnumed-devel] Server replication

[Busser, Jim]

On 2012-07-04, at 3:42 PM, 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?

        http://bucardo.org/check_postgres/check_postgres.pl.html#description

?

-- Jim