diff options
| -rw-r--r-- | net-mgmt/Makefile | 1 | ||||
| -rw-r--r-- | net-mgmt/nagios-check_postgres/Makefile | 114 | ||||
| -rw-r--r-- | net-mgmt/nagios-check_postgres/distinfo | 2 | ||||
| -rw-r--r-- | net-mgmt/nagios-check_postgres/pkg-descr | 9 | ||||
| -rw-r--r-- | net-mgmt/nagios-check_postgres/pkg-plist | 64 |
5 files changed, 190 insertions, 0 deletions
diff --git a/net-mgmt/Makefile b/net-mgmt/Makefile index 454089d986a9..9326b089e14e 100644 --- a/net-mgmt/Makefile +++ b/net-mgmt/Makefile @@ -126,6 +126,7 @@ SUBDIR += nagios-check_mysql_slave SUBDIR += nagios-check_netsnmp SUBDIR += nagios-check_ports + SUBDIR += nagios-check_postgres SUBDIR += nagios-check_puppet SUBDIR += nagios-check_smartmon SUBDIR += nagios-check_tftp diff --git a/net-mgmt/nagios-check_postgres/Makefile b/net-mgmt/nagios-check_postgres/Makefile new file mode 100644 index 000000000000..c05221216ed4 --- /dev/null +++ b/net-mgmt/nagios-check_postgres/Makefile @@ -0,0 +1,114 @@ +# Created by: Matthew Seaman <matthew@FreeBSD.org> +# $FreeBSD$ + +PORTNAME= check_postgres +PORTVERSION= 2.21.0 +CATEGORIES= net-mgmt databases perl5 +MASTER_SITES= http://bucardo.org/downloads/ +PKGNAMEPREFIX= nagios- + +MAINTAINER= matthew@FreeBSD.org +COMMENT= Monitor various attributes of your PostgreSQL database + +LICENSE= BSD2CLAUSE + +NO_ARCH= yes + +USES= perl5 +USE_PERL5= configure +USE_PGSQL= yes + +# This script is primarily used for monitoring via Nagios, but it also +# has output styles compatible with cacti or mrtg. The options +# control whether symlinks get made to locations where those +# applications expect to find their plugin scripts. + +OPTIONS_DEFINE= NAGIOS CACTI +OPTIONS_DEFAULT= NAGIOS +OPTIONS_SUB= yes + +NAGIOS_DESC= Create symlinks in Nagios plugins dir +NAGIOS_PLUGINS= ${PREFIX}/libexec/nagios +NAGIOS_LINKS= archive_ready \ + autovac_freeze \ + backends \ + bloat \ + checkpoint \ + cluster_id \ + commitratio \ + connection \ + custom_query \ + database_size \ + disabled_triggers \ + disk_space \ + fsm_pages \ + fsm_relations \ + hitratio \ + hot_standby_delay \ + index_size \ + last_analyze \ + last_autoanalyze \ + last_autovacuum \ + last_vacuum \ + listener \ + locks \ + logfile \ + new_version_bc \ + new_version_box \ + new_version_cp \ + new_version_pg \ + new_version_tnm \ + pgagent_jobs \ + pgb_pool_cl_active \ + pgb_pool_cl_waiting \ + pgb_pool_maxwait \ + pgb_pool_sv_active \ + pgb_pool_sv_idle \ + pgb_pool_sv_login \ + pgb_pool_sv_tested \ + pgb_pool_sv_used \ + pgbouncer_backends \ + pgbouncer_checksum \ + prepared_txns \ + query_runtime \ + query_time \ + relation_size \ + replicate_row \ + same_schema \ + sequence \ + settings_checksum \ + slony_status \ + table_size \ + timesync \ + txn_idle \ + txn_time \ + txn_wraparound \ + version \ + wal_files + +CACTI_DESC= Create symlinks in Cacti scripts dir +CACTI_SCRIPTS= ${PREFIX}/share/cacti/scripts +CACTI_LINKS= dbstats + +.include <bsd.port.options.mk> + +post-install: +.if ${PORT_OPTIONS:MNAGIOS} + @${MKDIR} ${STAGEDIR}${NAGIOS_PLUGINS} +.for l in ${NAGIOS_LINKS} + ${LN} -s ../../bin/check_postgres.pl \ + ${STAGEDIR}${NAGIOS_PLUGINS}/check_postgres_${l} +.endfor +.endif +.if ${PORT_OPTIONS:MCACTI} + @${MKDIR} ${STAGEDIR}${CACTI_SCRIPTS} +.for l in ${CACTI_LINKS} + ${LN} -s ../../../bin/check_postgres.pl \ + ${STAGEDIR}/${CACTI_SCRIPTS}/check_postgresql_${l} +.endfor +.endif + +regression-test: build + @cd ${WRKSRC} && ${MAKE} test + +.include <bsd.port.mk> diff --git a/net-mgmt/nagios-check_postgres/distinfo b/net-mgmt/nagios-check_postgres/distinfo new file mode 100644 index 000000000000..946003c13c60 --- /dev/null +++ b/net-mgmt/nagios-check_postgres/distinfo @@ -0,0 +1,2 @@ +SHA256 (check_postgres-2.21.0.tar.gz) = e0fdfe9c0d8188b6bb52896c87257a35311f5aea0f0e2ce332961be034314298 +SIZE (check_postgres-2.21.0.tar.gz) = 178511 diff --git a/net-mgmt/nagios-check_postgres/pkg-descr b/net-mgmt/nagios-check_postgres/pkg-descr new file mode 100644 index 000000000000..9dcfa2240699 --- /dev/null +++ b/net-mgmt/nagios-check_postgres/pkg-descr @@ -0,0 +1,9 @@ +check_postgres.pl - a Postgres monitoring script for Nagios, MRTG, +Cacti, and others + +check_postgres.pl is a Perl script that runs many different tests +against one or more Postgres databases. It uses the psql program to +gather the information, and outputs the results in one of three +formats: Nagios, MRTG, or simple. + +WWW: http://bucardo.org/wiki/Check_postgres diff --git a/net-mgmt/nagios-check_postgres/pkg-plist b/net-mgmt/nagios-check_postgres/pkg-plist new file mode 100644 index 000000000000..0a9716046cbd --- /dev/null +++ b/net-mgmt/nagios-check_postgres/pkg-plist @@ -0,0 +1,64 @@ +bin/check_postgres.pl +%%SITE_PERL%%/%%PERL_ARCH%%/auto/check_postgres/.packlist +%%NAGIOS%%libexec/nagios/check_postgres_archive_ready +%%NAGIOS%%libexec/nagios/check_postgres_autovac_freeze +%%NAGIOS%%libexec/nagios/check_postgres_backends +%%NAGIOS%%libexec/nagios/check_postgres_bloat +%%NAGIOS%%libexec/nagios/check_postgres_checkpoint +%%NAGIOS%%libexec/nagios/check_postgres_cluster_id +%%NAGIOS%%libexec/nagios/check_postgres_commitratio +%%NAGIOS%%libexec/nagios/check_postgres_connection +%%NAGIOS%%libexec/nagios/check_postgres_custom_query +%%NAGIOS%%libexec/nagios/check_postgres_database_size +%%NAGIOS%%libexec/nagios/check_postgres_disabled_triggers +%%NAGIOS%%libexec/nagios/check_postgres_disk_space +%%NAGIOS%%libexec/nagios/check_postgres_fsm_pages +%%NAGIOS%%libexec/nagios/check_postgres_fsm_relations +%%NAGIOS%%libexec/nagios/check_postgres_hitratio +%%NAGIOS%%libexec/nagios/check_postgres_hot_standby_delay +%%NAGIOS%%libexec/nagios/check_postgres_index_size +%%NAGIOS%%libexec/nagios/check_postgres_last_analyze +%%NAGIOS%%libexec/nagios/check_postgres_last_autoanalyze +%%NAGIOS%%libexec/nagios/check_postgres_last_autovacuum +%%NAGIOS%%libexec/nagios/check_postgres_last_vacuum +%%NAGIOS%%libexec/nagios/check_postgres_listener +%%NAGIOS%%libexec/nagios/check_postgres_locks +%%NAGIOS%%libexec/nagios/check_postgres_logfile +%%NAGIOS%%libexec/nagios/check_postgres_new_version_bc +%%NAGIOS%%libexec/nagios/check_postgres_new_version_box +%%NAGIOS%%libexec/nagios/check_postgres_new_version_cp +%%NAGIOS%%libexec/nagios/check_postgres_new_version_pg +%%NAGIOS%%libexec/nagios/check_postgres_new_version_tnm +%%NAGIOS%%libexec/nagios/check_postgres_pgagent_jobs +%%NAGIOS%%libexec/nagios/check_postgres_pgb_pool_cl_active +%%NAGIOS%%libexec/nagios/check_postgres_pgb_pool_cl_waiting +%%NAGIOS%%libexec/nagios/check_postgres_pgb_pool_maxwait +%%NAGIOS%%libexec/nagios/check_postgres_pgb_pool_sv_active +%%NAGIOS%%libexec/nagios/check_postgres_pgb_pool_sv_idle +%%NAGIOS%%libexec/nagios/check_postgres_pgb_pool_sv_login +%%NAGIOS%%libexec/nagios/check_postgres_pgb_pool_sv_tested +%%NAGIOS%%libexec/nagios/check_postgres_pgb_pool_sv_used +%%NAGIOS%%libexec/nagios/check_postgres_pgbouncer_backends +%%NAGIOS%%libexec/nagios/check_postgres_pgbouncer_checksum +%%NAGIOS%%libexec/nagios/check_postgres_prepared_txns +%%NAGIOS%%libexec/nagios/check_postgres_query_runtime +%%NAGIOS%%libexec/nagios/check_postgres_query_time +%%NAGIOS%%libexec/nagios/check_postgres_relation_size +%%NAGIOS%%libexec/nagios/check_postgres_replicate_row +%%NAGIOS%%libexec/nagios/check_postgres_same_schema +%%NAGIOS%%libexec/nagios/check_postgres_sequence +%%NAGIOS%%libexec/nagios/check_postgres_settings_checksum +%%NAGIOS%%libexec/nagios/check_postgres_slony_status +%%NAGIOS%%libexec/nagios/check_postgres_table_size +%%NAGIOS%%libexec/nagios/check_postgres_timesync +%%NAGIOS%%libexec/nagios/check_postgres_txn_idle +%%NAGIOS%%libexec/nagios/check_postgres_txn_time +%%NAGIOS%%libexec/nagios/check_postgres_txn_wraparound +%%NAGIOS%%libexec/nagios/check_postgres_version +%%NAGIOS%%libexec/nagios/check_postgres_wal_files +man/man1/check_postgres.1p.gz +%%CACTI%%share/cacti/scripts/check_postgresql_dbstats +%%CACTI%%@dirrmtry share/cacti/scripts +%%CACTI%%@dirrmtry share/cacti +%%NAGIOS%%@dirrmtry libexec/nagios +@dirrmtry %%SITE_PERL%%/%%PERL_ARCH%%/auto/check_postgres |