koji scratch build http://koji.fedoraproject.org/koji/taskinfo?taskID=6074235

Drop-by ideas:

1. Requires:	perl-DBD-Pg

Have you tried

Requires:       perl(:MODULE_COMPAT_%(eval "`%{__perl} -V:version`"; echo $version))

If RPM still can't find perl-DBD-Pg, you should add it.

However, I would have question about 

Requires:	perl-DBD-Pg

Since Fedora never suggests this way but this:

perl(DBD::Pg).

2. Better add a comment at %build so we know nothing is going to be built.

3. %description
PgToolkit is a collection of tools for PostgreSQL maintenance. 
PgToolkit so far uses the utility pgcompact to reduce PostgreSQL table and index bloat from databases. 

Too long, longer than 79 chars limitation, please change.

4. cp -drv lib/PgToolkit/ %{buildroot}%{perl_archlib}

-->

cp -adrv lib/PgToolkit/ %{buildroot}%{perl_archlib}

5. I would just write:

%{perl_archlib}/PgToolkit


to replace tons of lines in %files.

BTW I think %{perl_archlib} is wrong for noarch packages.

I'll review this

Thanks for the comments Christopher, suggestions have been applied. 

SPEC: http://dbmacartney.fedorapeople.org/pgtoolkit/pgtoolkit.spec
SRPM: http://dbmacartney.fedorapeople.org/pgtoolkit/pgtoolkit-1.0.0-2.fc19.src.rpm

koji scratch build: http://koji.fedoraproject.org/koji/taskinfo?taskID=6074952

Contacted author of pgtoolkit for confirmation of license as tarball was not very clear. Updated spec to use PostgreSQL license. 

SPEC: http://dbmacartney.fedorapeople.org/pgtoolkit/pgtoolkit.spec
SRPM: http://dbmacartney.fedorapeople.org/pgtoolkit/pgtoolkit-1.0.0-3.fc19.src.rpm

koji scratch build: http://koji.fedoraproject.org/koji/taskinfo?taskID=6082795

1. 1.0.1 is out

2. Leave a blank line between each changelog.

3. Peter, what about you?

SPEC: http://dbmacartney.fedorapeople.org/pgtoolkit/pgtoolkit.spec
SRPM: http://dbmacartney.fedorapeople.org/pgtoolkit/pgtoolkit-1.0.1-1.fc20.src.rpm

koji scratch build: http://koji.fedoraproject.org/koji/taskinfo?taskID=6518993

APPROVED

+ rpmlint output

$ rpmlint pgtoolkit.spec pgtoolkit-1.0.1-1.fc20.src.rpm pgtoolkit-1.0.1-1.fc20.noarch.rpm
pgtoolkit.src: W: spelling-error %description -l en_US pgcompact -> pg compact, pg-compact, compact
pgtoolkit.noarch: W: no-manual-page-for-binary pgcompact
2 packages and 1 specfiles checked; 0 errors, 2 warnings.

+ package name satisfies the packaging naming guidelines
+ specfile name matches the package base name
+ package should satisfy packaging guidelines
+ license meets guidelines and is acceptable to Fedora
+ license matches the actual package license
+ latest version packaged
+ %doc includes license file
+ spec file written in American English
+ spec file is legible
+ upstream sources match sources in the srpm
6eadf87b604478048736e5ca06af54b7  v1.0.1.tar.gz
+ package successfully builds on at least one architecture
  tested using koji scratch build
+ BuildRequires list all build dependencies
n/a %find_lang instead of %{_datadir}/locale/*
n/a binary RPM with shared library files must call ldconfig in %post and %postun+ does not use Prefix: /usr
n/a package owns all directories it creates
n/a no duplicate files in %files
+ Package perserves timestamps on install
+ Permissions on files must be set properly 
+ consistent use of macros
+ package must contain code or permissible content
n/a large documentation files should go in -doc subpackage
+ files marked %doc should not affect package runtime 
n/a header files should be in -devel
n/a static libraries should be in -static
n/a packages containing pkgconfig (.pc) files need 'Requires: pkgconfig'
n/a libfoo.so must go in -devel
n/a devel must require the fully versioned base
+ packages should not contain libtool .la files
n/a packages containing GUI apps must include %{name}.desktop file
+ packages must not own files or directories owned by other packages
+ filenames must be valid UTF-8

Optional:

+ if there is no license file, packager should query upstream to include it
n/a translations of description and summary for non-English languages, if
available
+ reviewer should build the package in mock/koji
n/a the package should build into binary RPMs on all supported architectures
n/a review should test the package functions as described
+ scriptlets should be sane
n/a non -devel packages should require fully versioned base
n/a pkgconfig files should go in -devel
+ shouldn't have file dependencies outside /etc /bin /sbin /usr/bin or
/usr/sbin

New Package GIT Request
=======================
Package Name: pgtoolkit
Short Description: Tools for PostgreSQL maintenance
Owners: dbmacartney
Branches: F-20 F-19 EL-6
InitialCC:

Git done (by process-git-requests).