Re: pgtap in our apt repo - Mailing list pgsql-pkg-debian

On Tue, 26 May 2015 22:26:58 +0200
Markus Wanner <markus@bluegap.ch> wrote:

> On 05/25/2015 09:03 PM, Christoph Berg wrote:
> > For an arch:all package you could stuff all extensions into a single
> > package and make symlinks for the duplicated files. I've done that for
> > ... *search disk* ... pgagent.
>
> Interesting.. just a couple days ago I started to work on PGAPT-ing
> pgtap as well. As with other packages before, I think the hardest part
> is to make the Makefile VPATH aware. I intend to file a patch upstream,
> soon-ish. Next step: autopkgtesting.
>
> Regarding packaging: I don't think there's enough flesh to warrant a
> -common package, as the per-Pg-package weigh in at around 90K. I'm
> considering a separate -doc package, though. (Barely heavier, either.)
>
> Also note that pgtap already is in Debian (well, has been). I contacted
> the current maintainer (Pierre Chifflier AKA pollux), but didn't get
> feedback on how he prefers me to contribute. Pierre?

Markus, did you notice that I took the existing deb-src package (0.90.0) from debian, and used uupdate to pull in the
0.95.1source and rebuild against 9.4 on Ubuntu 14.04? In fact, I'll forward all of you the message now. It worked fine,
sowe shouldn't need to create our own. All we need to do is decide if this existing package should try to put the
extensionfiles automagically in all expected locations for all installed versions (not fool-proof), or instead make
pgtap-9.1-9.2, etc. packages built against (and requiring each version of pg) which I think is the more correct thing
todo.  

One since source package, that ala skytools, builds a .deb for each version of pg it detects as installed on the build
hostautomagically.  

The contents of the one I built look like this:

jon@stuck:~/debs$ dpkg-deb -c pgtap_0.95.1-0ubuntu1_all.deb
drwxr-xr-x root/root         0 2015-05-25 14:22 ./
drwxr-xr-x root/root         0 2015-05-25 14:22 ./usr/
drwxr-xr-x root/root         0 2015-05-25 14:22 ./usr/share/
drwxr-xr-x root/root         0 2015-05-25 14:22 ./usr/share/postgresql/
drwxr-xr-x root/root         0 2015-05-25 14:22 ./usr/share/postgresql/9.4/
drwxr-xr-x root/root         0 2015-05-25 14:22 ./usr/share/postgresql/9.4/extension/
-rw-r--r-- root/root    298473 2015-05-25 14:22 ./usr/share/postgresql/9.4/extension/pgtap--0.95.0.sql
-rw-r--r-- root/root    183173 2015-05-25 14:22 ./usr/share/postgresql/9.4/extension/pgtap-schema--0.95.0.sql
-rw-r--r-- root/root     54374 2015-05-25 14:22 ./usr/share/postgresql/9.4/extension/pgtap--0.91.0--0.92.0.sql
-rw-r--r-- root/root     16657 2015-05-25 14:22 ./usr/share/postgresql/9.4/extension/pgtap--0.94.0--0.95.0.sql
-rw-r--r-- root/root    115279 2015-05-25 14:22 ./usr/share/postgresql/9.4/extension/pgtap-core--0.95.0.sql
-rw-r--r-- root/root      5504 2015-05-25 14:22 ./usr/share/postgresql/9.4/extension/pgtap--0.93.0--0.94.0.sql
-rw-r--r-- root/root       177 2015-05-25 14:22 ./usr/share/postgresql/9.4/extension/pgtap.control
-rw-r--r-- root/root     47343 2015-05-25 14:22 ./usr/share/postgresql/9.4/extension/pgtap--unpackaged--0.91.0.sql
-rw-r--r-- root/root     20921 2015-05-25 14:22 ./usr/share/postgresql/9.4/extension/pgtap--0.92.0--0.93.0.sql
-rw-r--r-- root/root       731 2015-05-25 14:22 ./usr/share/postgresql/9.4/extension/pgtap--0.90.0--0.91.0.sql
drwxr-xr-x root/root         0 2015-05-25 14:22 ./usr/share/doc/
drwxr-xr-x root/root         0 2015-05-25 14:22 ./usr/share/doc/postgresql-doc-9.4/
drwxr-xr-x root/root         0 2015-05-25 14:22 ./usr/share/doc/postgresql-doc-9.4/extension/
-rw-r--r-- root/root     45898 2015-05-25 14:22 ./usr/share/doc/postgresql-doc-9.4/extension/pgtap.mmd.gz
drwxr-xr-x root/root         0 2015-05-25 14:22 ./usr/share/doc/pgtap/
-rw-r--r-- root/root      1332 2011-06-11 09:40 ./usr/share/doc/pgtap/copyright
-rw-r--r-- root/root      1231 2015-05-25 14:22 ./usr/share/doc/pgtap/changelog.Debian.gz
-rw-r--r-- root/root     45898 2015-05-25 14:22 ./usr/share/doc/pgtap/pgtap.mmd.gz
drwxr-xr-x root/root         0 2015-05-25 14:22 ./usr/bin/
jon@stuck:~/debs$


> Myon: Am I correct that PGAPT needs a git repo to fetch from? Or can we
> handle other sources, there?
>
> Regards
>
> Markus Wanner
--
Jon Erdman <jon.erdman@bluetreble.com>
Sr. Data Engineer, Blue Treble Solutions, LLC
312.285.6735