A fast PostgreSQL Log Analyzer
2016-09-02 - v9.0
This major release of pgBadger is a port to bootstrap 3 and a version upgrade of all resources files (CSS and Javascript). There's also some bugs fixes and features enhancements.
Backward compatibility with old incremental report might be preserved.
- Sources and licences of resources files are now on a dedicated
subdirectory. A script to update their minified version embedded
in pgbager script has been added. Thanks to Christoph Berg for
the help and feature request.
- Try to detect user/database/host from connection strings if
log_connection is enabled and log_line_prefix doesn't include
them.
Extend the regex to autodetect database name, user name, client
ip address and application name. The regex now are the following:
db => qr/(?:db|database)=([^,]*)/;
user => qr/(?:user|usr)=([^,]*)/;
client => qr/(?:client|remote|ip|host)=([^,]*)/;
appname => qr/(?:app|application)=([^,]*)/;
- Add backward compatibility with older version of pgbadger in
incremental mode by creating a subdirectory for new CSS and
Javascript files. This subdirectory is named with the major
version number of pgbadger.
- Increase the size of the pgbadger logo that appears too small
with the new font size.
- Normalize detailed information in all reports.
- Fix duplicate copy icon in locks report.
- Fix missing chart on histogram of session time. Thanks to
Guillaume Lelarge for the report.
- Add LICENSE file noting the licenses used by the resource
files. Thanks to Christoph Berg for the patch.
- Add patch to jqplot library to fix an infinite loop when trying
to download some charts. Thanks to Julien Tachoires for the help
to solve this issue.
- Script tools/updt_embedded_rsc.pl will apply the patch to resource
file resources/jquery.jqplot.js and doesn't complain if it has
already been applied.
- Remove single last comma at end of pie chart dataset. Thanks to
Julien Tachoires for the report.
- Change display of normalized error
- Remove unused or auto-generated files
- Update all resources files (js+css) and create a directory to
include source of javascript libraries used in pgbadger. There is
also a new script tools/updt_embedded_rsc.pl the can be used to
generate the minified version of those files and embedded them
into pgbadger. This script will also embedded the FontAwesome.otf
open truetype font into the fontawesome.css file.
2016-08-27 - v8.3
This is a maintenance release that fix some minor bugs. This release also adds replication command messages statistics to the Events reports.
This is the last minor version of the 8.x series, next major version will include an upgrade of boostrap and jquery libraries which need some major rewrite.
2016-08-11 version 8.2
This is a maintenance release that fix some minor bug. There is also some performances improvement up to 20% on huge files and some new interesting features:
See ChangeLog for the complete list of changes.
2016-04-21 version 8.1
This is a maintenance release that fix a major issue introduced with support to pgbouncer that prevent parsing of compressed PostgreSQL log files and adds some improvements.
Here are the complete list of changes:
This is a major release that adds support to pgbouncer log files. New pgbouncer reports are:
pgbouncer log files can be parsed together with PostgreSQL logs.
It also adds a two new command line options:
This release fixes a major bug introduced with journalctl code that was prevented the use of multiprocess feature.
This is a maintenance release to fix a major bug that was breaking the incremental mode in pgBadger. It also adds some more reports and features.
This new release fixes some issues especially in temporary files reports and adds some features.
There's also some new command line option:
Adds --journalctl_cmd option to enable this functionality and set the command. Typically to parse output of PG 9.4 log:
--journalctl_cmd "journalctl -u postgresql-9.4"
to parse output of PG 9.4 log through the journalctl command.
See ChangeLog for the full list of changes/fixes.