On Fri, 2010-10-22 at 08:37 -0400, Chris Barnes wrote: > Is the a plugin or script that will allow pitr to be monitored and > trigger an alarm when the pitr master/slave databases > get out of sync? > > The reason I'm asking, I have had one or four of pitr'd slaves get out > of sync twice? > Not sure why, it may have something to do with rsync on (wal log > txfr), but not the point. PITRTools has a built-in Nagios notification system for pitr monitoring. Basically it uses nsca+nagios+passive check feature. You may want to use it, or use the logic in it: https://public.commandprompt.com/projects/pitrtools/ Regards, -- Devrim GÃNDÃZ PostgreSQL DanÄÅmanÄ/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment:
signature.asc
Description: This is a digitally signed message part
