PostgresQL

check_postgres

Write a Review

Description:

Check many things for a Postgres database, including connectivity, version, disk space used, table and index bloat, database size, relation size, locks, number of connections, transaction wraparound, and more.

Current Version

Last Release Date

May 28, 2009

Compatible With

Owner

Nagios Exchange

Website

http://bucardo.org/

Copy Page Link Recommend 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_postgres-2.11.1.tar.gz
Project Notes
Connects to one or more Postgres databases and checks for a variety of things. An action is either given on the command line, or inferred from the name of the executable by using symlinks. The current list of actions is: backends, bloat, connection, database_size, disk_space, index_size, last_analyze, last_vacuum, listener, locks, logfile, query_runtime, query_time, relation_size, settings_checksum, table_size, timesync, txn_wraparound, and version. Most standard nagios options are supported, including --timeout. All that is required is a local psql executable. Licensed under BSD, see web page for full documentation.
Reviews (7) Add a Review
Get the newest version from github
by tmoensted, November 30, 2016
https://github.com/bucardo/check_postgres/blob/master/check_postgres.pl
Helpful?    
Report
Nice !!
by morocho1979, May 31, 2016
i install , and use but in manuall mode i dont know hot to use in my server file yo check my postgres exist any guide with real examples
Helpful?    
Report
Sys Eng
by barthoosh, July 31, 2015
Freshest version is 2.22.0 (July 2015)
I'm using it for connections limit monitoring.
Common and useful.
Helpful?    
Report
All you need!
by egalstad, April 30, 2014
Usefull for me !!

If you uses action "query" (as: --action=custom_query --query="SELECT count (*) FROM pg_stat_activity"), you'll need tu put all right on "/tmp" (777 & t) :-)
Helpful?    
Report
Great
by Napsty, July 31, 2013
Was looking for a similar plugin like check_mysql to get some Postgres stats. check_postgres does the job and much more. Once I figured out how to use it correctly (--action is required), it worked great. Thanks for your work!
Helpful?    
Report
kudos
by lausser, July 31, 2013
I always wanted to write a check_postgres_health to join the family of my database plugins. But with an existing plugin like this one, it would be a waste of time.
So many features, consistent command line parameters, clean code... A very useful plugin!
Helpful?    
Report
Awesome!
by joehillen, March 31, 2012
This is one of the best plugins I have ever used. It is massive and has more features than I could dream of using.

It is also extremely well documented. Run:

./check_postgres.pl --man

to see it in action. Be sure to install perl-doc.

It is still maintained as of March 8, 2012 at:

http://bucardo.org/wiki/Check_postgres
Helpful?    
Report
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
5 (11)
Favorites
6
Views
169,564