To do so you have to change the following entries in your nf Create database user dedicated to read data from PostgreSQL statistic views.Įnable extensive query logging in PostgreSQL.To start the PostgresSQL server monitoring you should follow theese steps: The Add-on for PostgreSQL provides data inputs for PostgreSQL server which facilitate retrieving data from PostgreSQL standard statistic views (as pg_stat and pg_statio table) and from standard PostgreSQL server logs. The Add-on for PostgreSQL is available from Splunk Apps. This add-on should be installed onto the universal forwarder (or searchhead or indexer) from which you want to collect PostgreSQL data. In order to collect data from the PostgreSQL servers, you need the Add-on for Postgres. You need to have psycopg2 python module installed on your system as well as python itself (version 2.6 or later). Most of information is a base for App for Postgres appliaction with fancy dashboards and useful macros on board Prerequisites It is intended to provide deep dive into PostgreSQL database internals and metrics. This add-on dedicated to PostgreSQL monitoring.
0 kommentar(er)
