PostgresQL

Postgresql 9.3 Streaming Replication Delay

Write a Review

Description:

Python script to check and graph the delay in seconds from your primary to your hot standby PostgreSQL 9.3 server.

Current Version

Last Release Date

August 21, 2015

Compatible With

  • Nagios 3.x
  • Nagios 4.x

Owner

Kirk Hammond

Website

https://github.com/Winnux76

Download URL

https://github.com/Winnux76/Nagios

License

GPL

Copy Page Link Recommend Contact Owner Login to Add to Favorites Login to Claim
Nagios CSP

Meet The New Nagios Core Services Platform

Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.

Download Now

Monitoring Made Magically Better

  • Nagios Core on Overdrive
  • Powerful Monitoring Dashboards
  • Time-Saving Configuration Wizards
  • Open Source Powered Monitoring On Steroids
  • And So Much More!
Project Files
FileDescription
check_repdelay.py

Python Script

check_repdel.php

pnp4nagios template

Project Notes
This script will check the delay in seconds of your PostgreSQL 9.3 hot standby. I am assuming that users are familiar enough with PostgreSQL and the use of .pgpass that I don't need to cover the full setup details here. Written for CentOS 6.x using Python 2.6.6 (current version on CentOS 6 at time of writing) I suspect it will work on 2.6.9 without issue, I have not tested on 3.x For security purposes, I suggest using a .pgpass file in your nrpe users home director (CentOS 6.x = /var/run/nrpe/). This will allow you to leave the -P/--password field blank and only provide a username which you reference in the .pgpass file. To test if the script runs as the nrpe user, the follow command run as root will execute it as the nrpe user. sudo su nrpe -c '/usr/lib64/nagios/plugins/check_repdelay.py' -s /bin/bash You can add -C and -W levels inside the single quotes for testing functionality. The .php template for pnp4nagios is provided.
Reviews (0) Add a Review
Add a Review

You must be logged in to submit a review.

Thank you for your review!

Your review has been submitted and is pending approval.

Recommend

To:


From:


Thank you for your recommendation!

Your recommendation has been sent.

Page Sections
Project Overview Project Files Project Notes Reviews
Project Stats
Rating
0 (0)
Favorites
0
Views
9,305