pgbadger-13.1-bp160.1.2

- fix build on Tumbleweed - add pgbadger-13.1-precedence.patch

- update to 13.1
  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.

- update to 13.0
  This is a major release of pgBadger that fixes issues reported by
  users since last release and adds some new features:
  - Add two new option to be able to redefined inbound of query and
    session histogram. Thanks to JosefMachytkaNetApp for the
    feature request.
  - -histogram-query VAL   : use custom inbound for query
    times histogram.
    Default inbound in milliseconds:
    0,1,5,10,25,50,100,500,1000,10000
  - -histogram-session VAL : use custom inbound for session
    times histogram.
    Default inbound in milliseconds:
    0,500,1000,30000,60000,600000,
    1800000,3600000,28800000
  - Add support of auto_explain plan for csv and json log formats.
    Thanks to zxwsbg and to Alexander Rumyantsev for the report.
  - Add three LOG message that was not reported as events:
    unexpected EOF, incomplete startup packet and detected deadlock
    while waiting for. Thanks to dottle for the report.
  Backward compatibility issues:
  - Change the way LOG level events reported in the Events reports
    are stored. Some of them was still reported and counted as
    errors instead as LOG level entries. The fix is to stored and
    report them as EVENTLOG to differentiate them from queries.
    This change introduce a backward compatibility break when
    pgbadger is used in incremental mode. You will just have the
    double behavior during the week of the upgrade. Thanks to Matti
    Linnanvuori for the report.
  Bug fixes:
  - Fix non reported queries generating the most cancellation due
    to statement_timeout.
  - Update regression tests
  - Fix formatting of explain plan when extracted from csv log
    format.
  - Fix jsonlog missing autovacuum data reports: Average Autovacuum
    Duration, Tuples removed per table and vacuums by hour in
    autovacuum activity report. Thanks to Ales Zeleny for the
    patch.
  - Fix orphan line not associated to the time consuming bind
    queries. Thanks to Henrietta Dombrovskaya for the report. Fix
    use of uninitialized value in pattern match. Thanks to Junior
    Dias for the patch.
  - Apply option --csv-separator to raw export to CSV. Default
    separator is semicolon (;). Thanks to Henrietta Dombrovskaya
    for the feature request.
  - Raw csv output: do not add double quote to parameters and
    application name if they are empty.
  - Add double quotes when queries have a semi colon in raw csv
    output. Thanks to Henrietta Dombrovskaya for the report.

- Disabling cronjobs on any non-systemd distribution.

- 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.

- 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
- Package rename: provide and obsolete the old PgBadger package

- added pgbadger-rpmlintrc as source

- renamed package to pgbadger

- modified Source0

- added rpmlint filter for crontabs

- removed clean macro

- alligned changes file to the OBS project name

- alligned "Name:" tag and spec file name to the OBS project name

- update to 12.2
  https://github.com/darold/pgbadger/releases/tag/v12.2

- update to 12.1
  https://github.com/darold/pgbadger/releases/tag/v12.1

- update to 12.0
  https://github.com/darold/pgbadger/releases/tag/v12.0

- update to 11.8
  https://github.com/darold/pgbadger/releases/tag/v11.8
- drop 716.diff:
  included in update

- apply upstream test fix 716.diff
  https://github.com/darold/pgbadger/pull/716

- update to 11.7
  https://github.com/darold/pgbadger/releases/tag/v11.7

- update to 11.6
  https://github.com/darold/pgbadger/releases/tag/v11.5
  https://github.com/darold/pgbadger/releases/tag/v11.6

- update to 11.4
  https://github.com/darold/pgbadger/releases/tag/v11.2
  https://github.com/darold/pgbadger/releases/tag/v11.3
  https://github.com/darold/pgbadger/releases/tag/v11.4

- BR for cron for directory ownership

- update to 11.1
  - please refer to /usr/share/doc/packages/pgbadger/ChangeLog for a
    complete list of changes. The following is just an excerpt
  - This new release breaks backward compatibility with old binary or JSON
    files. This also mean that incremental mode will not be able to read
    old binary file. If you want to update pgBadger and keep you old reports
    take care to upgrade at start of a new week otherwise weekly report will
    be broken. pgBadger will print a warning and just skip the old binary
    file.
  - From 9.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.
  - Add support of pgbouncer syslog log file format.
  - Add support to all auto_explain format (text, xml, json and yaml).
  - Add support to %q placeholder in log_line_prefix.
  - Add jsonlog format of Michael Paquier extension, with -f jsonlog
    pgbadger will be able to parse the log.
  - Add report of checkpoint distance and estimate.
  - Add support of AWS Redshift keywords to SQL code beautifier.
  - Add autodetection of log format in remote mode to allow remote
    parsing of pgbouncer log file together with PostgreSQL log file.
  - Replace the SQL formatter/beautify with v3.0 of pgFormatter.
  - Add report of error class distribution when SQLState is available
    in the log_line_prefix (see %e placeholder).
  - Update SQL Beautifier to pgFormatter v1.6 code.
  - Improve error message normalization.
  - Add --normalized-only option to generate a text file containing all
    normalized queries found in a log with count.
  - Allow %c (session id) to replace %p (pid) as unique session id.
  - Add waiting for lock messages to event reports.
  - Add --start-monday option to start calendar weeks in Monday
    instead of default to Sunday.
  - Add report of top N queries that consume the most time in the
    prepare or parse stage.
  - Add report of top N queries that consume the most time in the
    bind stage.
  - Add report of timing for prepare/bind/execute queries parts.
    Reported in a new "Duration" tab in Global Stats report. This
    also fix previous report of "Total query duration" that was
    only reporting execute total duration.
  - Add support to RDS and CloudWatch log format, they are detected
    automatically. You can use -f rds if pgbadger is not able to
    auto-detect the log format.
  - Add new configuration option --month-report to be able to build
    monthly incremental reports.
  - Add top bind queries that generate the more temporary files.
    Require log_connection and log_disconnection be activated.
  - Add --exclude-client command line option to be able to exclude log
    entries for the specified client ip. Can be used multiple time.
  - Add -H, --html-dir option to be able to set a different path where
    HTML report must be written in incremental mode. Binary files stay
    on directory defined with -O, --outdir option.
  - Add -E | --explode option to explode the main report into one
    report per database. Global information not related to a database
    are added to the postgres database report.
  - Add per database report to incremental mode. In this mode there
    will be a sub directory per database with dedicated incremental
    reports.
  - Add support to Heroku's PostgreSQL logplex format.
- needs Pod::Markdown and JSON::XS to build now
- uses additional modules during runtime: Storable, File::Spec, File::Temp
  IO::Handle, IO::Pipe, FileHandle, Socket, Encode, Text::Wrap
- new upstream URL
- disable tests on SLE, as there is no JSON::XS available
- added some cron examples in /etc/cron.d/pgbadger