PostgreSQL Log Analyzer v2.0

INSTALLATION INSTRUCTION

There's some requirement to have it works. First of all you
must have a modern perl distribution, version 5.6.x or more.

PgAnalyser use the Gd library with some perl modules to draw
graph.

	Lib GD 1.8.4 is the version I use, but other version
	may works. Graph images are in PNG format so you also
	need libpng and lib gd must be compliled with png support.

	The following perl modules are required:
		GD
		GD::Graph
		GD::Graph::bars3d

	Take the latest version from CPAN (http://search.cpan.org)

After installing these required software, just type the following
commands:

	perl Makefile.PL
	make
	make install

This will copy the PgAnalyzer.pm perl module into your site_perl
directory.

Then edit the pganalyzer.conf file to match your configuration and
installation needs. Copy this file in /etc/.

Add the pg-analyzer perl script into /usr/local/bin or other directory
and all is done.

If you have put the configuration file into /etc/pganalyzer.conf, you
can run pg-analyzer without command line argument else you must give
the path to the configuration file.

Install PostgreSQL log analyzer into a daily crontab to have incremental
report. Take care if you have enable logrotate to run it before rotation
is done.

I have a daily rotation of my serverlog file (rotate is done at 04:00 am)
and I have include this line into my crontab:

	0 3 * * * /usr/local/bin/pg-analyzer /etc/pganalyzer.conf

To finish installation just install the elephant logo at the rigth place
(as specified into the configuration file) and create the HTML and graph
output directory.

To know how it work and especially configuration option take a look at
README file.

That's all...

Gilles Darold

