PostgresQL

check_postgres

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


Project Files
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



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



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.



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



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!



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!



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



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.

Project Stats
Rating
5 (11)
Favorites
6
Views
169,545