Re: pgtap in our apt repo

On Tue, 26 May 2015 22:26:58 +0200
Markus Wanner <markus(at)bluegap(dot)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.1 source and rebuild against 9.4 on Ubuntu 14.04? In fact, I'll forward all of you the message now. It worked fine, so we shouldn't need to create our own. All we need to do is decide if this existing package should try to put the extension files 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 to do.

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

The contents of the one I built look like this:

jon(at)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(at)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(dot)erdman(at)bluetreble(dot)com>
Sr. Data Engineer, Blue Treble Solutions, LLC
312.285.6735