pgFouine is a postgresql log analyzer. This procedure explain how to install it on Ubuntu 10.04 (Lucid Lynx) as the installation tutorial given on the site (http://pgfouine.projects.postgresql.org/index.html) is not up-to-date.

INSTALL
-------
1. go in superuser mode
$ sudo su

2. install pgfouine
# apt-get install pgfouine

3.configure postgresl
# gedit /etc/postgresql/8.4/main/postgresql.conf

append that lines to the file:
#PGFOUINE CONFIG
log_destination = 'syslog'
silent_mode = on
log_min_duration_statement = 0
log_duration = off
log_statement = 'none'

make also sure that the language of the error messages is en_US.utf8 (lc_messages = 'en_US.utf8')

4.configure rsyslog
# gedit /etc/rsyslog.d/50-default.conf

append that lines to the file:
#PGFOUINE CONFIG
local0.*                -/var/log/psql.log
.info;mail.none;authpriv.none;cron.none;local0.none                /var/log/messages

5.restart postgresql and rsyslog
# restart rsyslog

# su postgres
$ /etc/init.d/postgresql-8.4 restart

6. test it's working correctly by doing some flow in openerp 

7. check the report given by pgfouine
# pgfouine -f psql.log > pgfouine.html
# firefox pgfouine.html