Publisher review:pg_statsinfo monitors an instance of a PostgreSQL server and gathers the statistics and activities of a server as snapshots. The snapshots will be stored in the same or another repository database.
It also parses PostgreSQL's CSV server log filesm and extracts performance logs from them. Error messages are routed into textlog and syslog according to the message levels.
pg_statsinfo can be easily installed and maintained because it starts or stops automatically when PostgreSQL server starts or stops.
Statistics counters from pg_statsinfo can be displayed with pg_reporter as graphicsl reports.
pg_statsinfo works as the following image. It monitors one PostgreSQL instance (server).
Two connections required if monitored instance and repository are on the same server.
If this isn't the case, 1 connection for the monitored instance / 1 connections for repository.
pg_statsinfo 2.3.0 is a script for Database Tools scripts design by Nippon Telegraph and Telephone Corporation.
It runs on following operating system: Windows / Linux and has as system requierments:
OS: RHEL 5.3, CentOS 5.3, Windows XP
PostgreSQL 8.3 or higher
.
Requirements:
- OS: RHEL 5.3, CentOS 5.3, Windows XP
- PostgreSQL 8.3 or higher
Operating system:Windows / Linux
pg_statsinfo 2.3.0 script details 
