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?
>
> http://bucardo.org/check_postgres/check_postgres.pl.html#description

Yes. Monitoring services is always a good idea.

Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

_______________________________________________
Gnumed-devel mailing list
Gnumed-devel@gnu....
https://lists.gnu.org/mailman/listinfo/gnumed-devel