NAME

postgres_xlog - Plugin to monitor the size of the PostgreSQL transaction log

CONFIGURATION

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;

SEE ALSO

Munin::Plugin::Pgsql

MAGIC MARKERS

 #%# family=auto
 #%# capabilities=autoconf

AUTHOR

Magnus Hagander <magnus@hagander.net>, Redpill Linpro AB

COPYRIGHT/License.

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.