Bug 904638

Summary: RFE: package/include pgbadger Gilles Darold ( Dalibo ) log analysing tool
Product: [Fedora] Fedora Reporter: Jóhann B. Guðmundsson <johannbg>
Component: postgresqlAssignee: Tom Lane <tgl>
Status: CLOSED NOTABUG QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: rawhideCC: devrim, hhorak, tgl
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-01-26 20:12:46 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
pgbadger.spec none

Description Jóhann B. Guðmundsson 2013-01-26 18:32:26 UTC 
Created attachment 688096 [details]
pgbadger.spec

Description of problem:

I assume you guys already have heard of this encase you have not pgbadger is just another postgresql log analysing tool written in perl and replaces pgfouin ( which does not seem to have been updated for quite some time ). 

I was not sure where you guys wanted this ( main package/contrib/separated standalone package ) so I created a pgbadger spec file and have it attached 

To test just download 2.2.1 release from here https://github.com/downloads/dalibo/pgbadger/pgbadger-2.2-1.tar.gz ( 2.3 has been released but there is no tar ball for it )

generate the rpm based on the attached spec file, install it and run 
# pgbadger  /var/lib/pgsql/data/pg_log/postgresql-Sat.log -o /var/www/html/pgbadger.html 

Start apache and point your browser http://localhost/pgbadger.html

If you dont already have log files to parse you can generate a data set to parse via pgbench

If there is any interest I can write a spec file for Gilles pgFormatter

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.
  
Actual results:


Expected results:


Additional info:
Comment 1 Tom Lane 2013-01-26 20:12:46 UTC 
This is not a postgresql bug, because it would be quite inappropriate to include pgbadger directly into the postgresql RPMs.  It's a separate upstream project with its own release schedule, version numbers, etc.

If you want to see pgbadger in Fedora the correct way is to submit it as a new package --- see https://fedoraproject.org/wiki/Package_Review_Process
Comment 2 Jóhann B. Guðmundsson 2013-01-26 20:44:55 UTC 
I dont have time nor any particular interest in maintaining packages in the distribution it simply does not float my boat. I dont mind fixing things as I come across them or write spec files if need be for various additional components in the distribution but there exist no place for people like me in the project. ( fixers not packagers atleast not without me going through that daunting process of becoming "packager" in the distribution )

I felt an itch to scratch since I noticed that we shipped pgfouin which seems to be no longer maintained upstream but not pgbadger which seems to be active and maintained and I thought the "PostgreSQL Global Development Group" or the postgresql community in the distribution would be interested in shipping this as an alternative or simply to obsolete pgfouine. 

Anyway the spec file is here for anyone to pick it up and maintain pgbadger in the distribution for those interested and are ready this...
Comment 3 Devrim Gündüz 2013-02-11 14:49:23 UTC 
FWIW, I'm already maintaining pgbadger in PostgreSQL RPM repository: http://yum.postgresql.org
Comment 4 Jóhann B. Guðmundsson 2013-02-11 20:55:34 UTC 
(In reply to comment #3)
> FWIW, I'm already maintaining pgbadger in PostgreSQL RPM repository:
> http://yum.postgresql.org

Interesting. 

Why the need for the Fedora repository's and where can I find the srpms?