Parámetros
| Parámetro | Descripción |
| -d,--database | Nombre de la base de datos (obligatorio) |
| -u,--user | Nombre del user de postgreSQL(obligatorio) |
| -p,-password | Password de postgreSQL (obligatorio) |
| -i,--ip | ip del server (obligatorio) |
| --port | puerto del server (obligatorio) |
| --agent_name | Para ponerle un nombre al agente que contendrá los módulos de las custom querys, por defecto : "PostgreSQL". (opcional) |
| --conf | Path del archivo conf con las querys (obligatorio) |
| -g,--group | Grupo de destino de Pandora FMS (opcional) |
| --data_dir | Directorio de datos de Pandora FMS. Por defecto es /var/spool/pandora/data_in/ (opcional) |
| --as_agent_plugin | Es opcional, si quieres que el plugin sea de agente y te meta los módulos en el agente de pandora, ejecuta esto con un 1 (opcional) |
Pandora_postgresql.conf
En este archivo se introducirán las querys que crearán módulos en PandoraFMS.
El formato para añadir las querys es el siguiente:
nombre_modulo:query:descripción* La descripción no es obligatoria, si no se introduce se quedará vacía.
Ejemplo:
number_connections:SELECT count(*) FROM pg_stat_activity;:Number of Connections or running backend
connections_waiting_in_locks:SELECT count(*) FROM pg_stat_activity WHERE wait_event = 'Lock';:Number of connections/backends waiting on locks
connections_idle_in_transaction:SELECT count(*) FROM pg_stat_activity WHERE wait_event = 'idle in transaction';
number_users:SELECT COUNT(usename) FROM pg_stat_activity;
number_roles:SELECT count(*) FROM pg_roles;
psql_version:SELECT version() ;
num_blocks:SELECT COUNT(*) FROM pg_locks;
psql_diskspace:SELECT ROUND(SUM(pg_database_size(oid))/1024/1024) FROM pg_database;
number_commits:SELECT sum(xact_commit) FROM (pg_database AS db JOIN pg_stat_database sdb ON db.datname=sdb.datname);
number_rollbacks:SELECT sum(xact_rollback) FROM (pg_database AS db JOIN pg_stat_database sdb ON db.datname=sdb.datname);
tuples_returned:SELECT sum(tup_returned) FROM (pg_database AS db JOIN pg_stat_database sdb ON db.datname=sdb.datname);
tuples_searched:SELECT sum(tup_fetched) FROM (pg_database AS db JOIN pg_stat_database sdb ON db.datname=sdb.datname);
tuples_inserted:SELECT sum(tup_inserted) FROM (pg_database AS db JOIN pg_stat_database sdb ON db.datname=sdb.datname);
tuples_updated:SELECT sum(tup_updated) FROM (pg_database AS db JOIN pg_stat_database sdb ON db.datname=sdb.datname);
tuples_removed:SELECT sum(tup_deleted) FROM (pg_database AS db JOIN pg_stat_database sdb ON db.datname=sdb.datname);