Quick Links

pgBadger 2.1 released

Posted on 2012-10-17 by Dalibo

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

[HTML_REMOVED]

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

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.

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.

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