Make Homepage | Add To Favorites | Print Page | Submit News | Feedback | Contact | 

Your Technical Computer Information Resource!  
  Technical Updates @ TACKtech Corp.  

10.17.2012 - pgBadger 2.1 released

View PostgreSQL-Press related news.

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

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 :


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


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

- Download PostgreSQL
- View Press Release
- Visit PostgreSQL

NID: 43626 / Submitted by: The Zilla of Zuron
Categories: Server Applications, Open Source, Press Release
Most recent PostgreSQL-Press related news.
Database .NET 19.8 released
PostgresDAC 3.2.0 with PostgreSQL 9.6 and Android support is out
repmgr 3.2 released
pglogical 1.2 Now Available
ppc64el packages now available on
View archive of PostgreSQL-Press related news.

Visit the TACKtech Shop
  Popular Tech News  
  Most Viewed News  
  Top Affiliates