postgres_xlog - Plugin to monitor the size of the PostgreSQL transaction log
Configuration is done through libpq environment variables, for example PGUSER, PGDATABASE, etc. For more information, see Munin::Plugin::Pgsql.
To monitor several instances, link to postgres_<tag>_xlog The <tag> can be what you want but without "_". It allows you to define several database configuration.
Example : [postgres_pg91_*] env.PGPORT 5432 [postgres_pg92_*] env.PGPORT 5432
Prior to PostgreSQL version 10, the user this plugin connects to the database as requires superuser privileges on the database:
ALTER ROLE your_nagios_user SUPERUSER;
Since version 10 the user only requires the pg_monitor role:
ALTER ROLE your_nagios_user NOSUPERUSER; GRANT pg_monitor TO your_nagios_user;
#%# family=auto #%# capabilities=autoconf
Magnus Hagander <firstname.lastname@example.org>, Redpill Linpro AB
Copyright (c) 2009 Magnus Hagander, Redpill Linpro AB
All rights reserved. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 dated June, 1991.