Обсуждение: Is there a plugin/script for nagios that monitors pitr being up to djavascript:;ate?

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.

Any help would be appreciated...

Chris Barnes

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

> 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:

Hi Devrim,

It's Escaping me where nagios is in the listing? I'm probably way off but more specifically if you could please?


-rwxr-xr-x 1 root 1017 12167 May  4 15:02 cmd_archiver
-rwxr-xr-x 1 root 1017   940 Jan  9  2009 cmd_archiver.ini.sample
-rwxr-xr-x 1 root 1017  3915 Dec 26  2008 cmd_archiver.README
-rwxr-xr-x 1 root 1017 15872 Apr 16  2009 cmd_standby
-rwxr-xr-x 1 root 1017  1476 Feb 20  2009 cmd_standby.ini.sample
-rwxr-xr-x 1 root 1017  3920 Feb  7  2009 cmd_standby.README
-rwxr-xr-x 1 root 1017   992 Apr 21  2009 cmd_standby.sql

On Fri, 2010-10-22 at 10:25 -0400, Chris Barnes wrote:
> It's Escaping me where nagios is in the listing? I'm probably way off
> but more specifically if you could please?

See cmd_archiver.ini file, mainly notify_ok, notify_warning and
notify_critical parameters. Using nsca+nagios, you can send passive
check results to nagios. We have done it several times.
--
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