- update to 13.2
This is a maintenance release of pgBadger that update SQL code
formatting, fixes issues and applied patches reported by users
since last release.
- Fix normalization that was not handling properly balanced
single-quoted strings along with escaped quotes inside. Thanks
to Bertrand Bourgier for the report.
- Fix placeholder requirements in the doc.
- Fix case where no error sample log entries was reported. Thanks
to john doe for the report.
- Fix possible precedence problem between ! and %s. Thanks to
Luca Santarelli and Philipp Trulson for the report. Update
pgFormatter code to v5.9 Add github CI action for testing on
commit push.
- Fix parsing of %r placeholder in log_line_prefix. Thanks to
nike7o0 for the report.
- Fix uninitialized value warning. Thanks to Ales Zeleny for the
report.
- Enhance docs of ssh-options for postgreSQL log parsing with
examples. Thanks to Ulrich Konrad for the patch.
- Add command --ssh-sudo to run commands over ssh as sudo. Thanks
to Andrew Jackson for the patch.
- Fix possible precedence problem between ! and string eq. Thanks
to Adrien Nayrat for the report.
- Fix parsing of pgbouncer stats. Thanks to mrgtt for the report.
- drop pgbadger-13.1-precedence.patch
OBS-URL: https://build.opensuse.org/request/show/1324730
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/pgbadger?expand=0&rev=4
This is a maintenance release of pgBadger that update SQL code
formatting, fixes issues and applied patches reported by users
since last release.
- Fix normalization that was not handling properly balanced
single-quoted strings along with escaped quotes inside. Thanks
to Bertrand Bourgier for the report.
- Fix placeholder requirements in the doc.
- Fix case where no error sample log entries was reported. Thanks
to john doe for the report.
- Fix possible precedence problem between ! and %s. Thanks to
Luca Santarelli and Philipp Trulson for the report. Update
pgFormatter code to v5.9 Add github CI action for testing on
commit push.
- Fix parsing of %r placeholder in log_line_prefix. Thanks to
nike7o0 for the report.
- Fix uninitialized value warning. Thanks to Ales Zeleny for the
report.
- Enhance docs of ssh-options for postgreSQL log parsing with
examples. Thanks to Ulrich Konrad for the patch.
- Add command --ssh-sudo to run commands over ssh as sudo. Thanks
to Andrew Jackson for the patch.
- Fix possible precedence problem between ! and string eq. Thanks
to Adrien Nayrat for the report.
- Fix parsing of pgbouncer stats. Thanks to mrgtt for the report.
- drop pgbadger-13.1-precedence.patch
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbadger?expand=0&rev=14
This is a maintenance release of pgBadger that fixes issues
reported by users since last release and adds some new features:
- Add new report about vacuum throughput with a graph about
vacuum per table that consume the more CPU. The table output
reports I/O timing read and write per table as well as the CPU
time elapsed on the table. Thanks to Ales Zeleny for the
feature request. This patch also adds frozen pages and tuples
to the Vacuums per Table report.
- Add --no-fork option for debugging purpose to not fork
processes at all. Thanks to Ales Zeleny for the feature
request.
- Add millisecond to the raw csv output. Thanks to Henrietta
Dombrovskaya for the feature request.
- Add log filename to sample reports when multiple file are
processed. Thanks to Adrien Nayrat for the feature request.
Here is the complete list of changes and acknowledgments:
- Fix bind parameters parsing. Thanks to Thomas Kotzian for the
patch
- Apply query filter on multi-lines queries. Thanks to Benjamin
Jacobs for the patch
- Update test result for log filename storage changes
- Fix ERROR vs LOG message level in json output. Thanks to
Philippe Viegas for the report.
- Remove import of tmpdir not exported method from File::Temp.
Thanks to kmoradha for the report.
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbadger?expand=0&rev=10
- update to 12.4
This is a maintenance release of pgBadger that fixes issues reported by
users since last release.
* Fix pgbouncer report with version 1.21. Thanks to Ales Zeleny for the patch.
* Prevent parallelism perl file to be higher than the number of files. Thanks
to maliangzhu for the report.
* Fix regression test broken since v12.3. Thanks to ieshin for the report.
* Fix cases where LOG entries where counted as ERROR log level entries. Thanks
to Matti Linnanvuori for the report.
OBS-URL: https://build.opensuse.org/request/show/1136083
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbadger?expand=0&rev=5
Move the cron and systemd files out into the documentation directory and
include an extended README.SUSE to show how to work with them.
- update to 12.3
This is a maintenance release of pgBadger that fixes issues reported by
users since last release. It also adds some new features:
* Add option --include-pid to only report events related to a session
pid (%p). Can be used multiple time. Thanks to Henrietta Dombrovskaya
for the feature request.
* Add option --include-session to only report events related to the
session id (%c). Can be used multiple time. Thanks to Henrietta Dombrovskaya
for the feature request.
* Add option --dump-raw-csv to only parse the log and dump the information
into CSV format. No further processing is done, no report is generated.
Thanks to Henrietta Dombrovskaya for the feature request.
Here is the complete list of changes and acknowledgments:
* Update pgFormatter to version 5.5
* Fix end date of parsing with jsonlog format. Thanks to jw1u1 for the report.
* Fix typo in "Sessions per application". Thanks to fairyfar for the patch.
* Fix "INSERT/UPDATE/DELETE Traffic" chart bug. Thanks to fairyfar for the
patch.
* Fix parsing of orphan lines with bind queries. Thanks to youxq for the
report.
* Fix Analyze per table report with new PG versions. Thanks to Jean-Christophe
Arnu for the patch.
* Fix syslog entry parser when the syslog timestamp contains milliseconds.
Thanks to Pavel Rabel for the report.
- add systemd timer examples: beside the existing cron job example, this
allows people to get an idea how to automate the generation of reports
- introduce local cron macro: only recommend cron on older distributions
and leave the cron example file where it was historically (but place it
into the examples folder on newer distributions).
- get rid of old suse_version 11.3 check
OBS-URL: https://build.opensuse.org/request/show/1130189
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbadger?expand=0&rev=4
