pgBadger 2.1 released - Mailing list pgsql-general

Paris, France - October 17th, 2012

DALIBO is proud to announce the release of version 2.1 of pgBadger, the
new PostgreSQL log analyzer. pgBadger is built for speed with fully
detailed reports from your PostgreSQL log file. It's a single and small
Perl script that aims to replace and to outperform the old PHP script
pgFouine.

===== pgBadger 2.1 allows more flexibility =====

pgBadger is back with a new release and some long-awaited features:

  * you can now use a custom log_line_prefix (see below)
  * you can provide log files compressed with gzip, bzip2 or zip tools
  * you can use log_duration instead of log_min_duration_statement

This new release comes with some bugfixes and many improvements such as :

  * Huge overhaul of the cvslog format parsing for better performance
  * New syslog-ng parser
  * Better handling of empty graphs and tables
  * Handling of autovacuum launcher messages
  * Report of configuration changes

For the complete list of changes, please checkout the release note on
https://github.com/dalibo/pgbadger/blob/master/ChangeLog

All pgBadger users should upgrade as soon as possible.


===== How to use the new --prefix parameter ? =====

With pgBadger 2.1, you don't need to modify the log_line_prefix
parameter in the postgresql.conf file. Instead you can use the --prefix
option to describe your log_line_prefix to pgBadger.

For instance, you can run the following command line:

perl pgbadger --prefix '%m %u@%d %p %r %a : ' postgresql.log

However, if you are using the stderr output, you will need to log at
least the timestamp (%t), the PID (%p) and the session/line number (%l).


===== Links & Credits =====

DALIBO would like to thank the developers who submitted patches and the
users who reported bugs and feature requests, especially Philip Freeman,
Casey Allen Shobe and Vincent Laborie. pgBadger is an open project. Any
contribution to build a better tool is welcome. You just have to send
your ideas, features requests or patches using the GitHub tools or
directly on our mailing list.

Links :

  * Download :  https://github.com/dalibo/pgbadger/downloads
  * Mailing List :
https://listes.dalibo.com/cgi-bin/mailman/listinfo/pgbagder




--------------

**About pgBadger** :

pgBagder is a new generation log analyzer for PostgreSQL, created by
Gilles Darold, also author of ora2pg migration tool. pgBadger is a fast
and easy tool to analyze your SQL traffic and create HTML5 reports with
dynamics graphs. pgBadger is the perfect tool to understand the behavior
of your PostgreSQL server and identify which SQL queries need to be
optimized.

Docs, Download & Demo at http://dalibo.github.com/pgbadger/

--------------

**About DALIBO** :

DALIBO is the leading PostgreSQL company in France, providing support,
trainings and consulting to its customers since 2005. The company
contributes to the PostgreSQL community in various ways, including :
code, articles, translations, free conferences and workshops

Check out DALIBO's open source projects at http://dalibo.github.com