Bug 904638 - RFE: package/include pgbadger Gilles Darold ( Dalibo ) log analysing tool
Summary: RFE: package/include pgbadger Gilles Darold ( Dalibo ) log analysing tool
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Fedora
Classification: Fedora
Component: postgresql
Version: rawhide
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Tom Lane
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-01-26 18:32 UTC by Jóhann B. Guðmundsson
Modified: 2013-02-11 20:55 UTC (History)
3 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2013-01-26 20:12:46 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)
pgbadger.spec (2.36 KB, text/x-rpm-spec)
2013-01-26 18:32 UTC, Jóhann B. Guðmundsson
no flags Details

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?


Note You need to log in before you can comment on or make changes to this bug.