Fw: Re: pgtap in our apt repo

Here you go. Included everyone on the other message rather than just you, just in case there had been other additions that hadn't seen this one.
--
Jon Erdman <jon(dot)erdman(at)bluetreble(dot)com>
Sr. Data Engineer, Blue Treble Solutions, LLC
312.285.6735

Begin forwarded message:

Date: Mon, 25 May 2015 14:23:23 -0500
From: Jon Erdman <jon(dot)erdman(at)bluetreble(dot)com>
To: Jon Erdman <jon(dot)erdman(at)bluetreble(dot)com>
Cc: Christoph Berg <myon(at)debian(dot)org>, David Wheeler <david(at)justatheory(dot)com>, Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>, Magnus Hagander <magnus(at)hagander(dot)net>, Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
Subject: Re: pgtap in our apt repo

Corrected: fixed the naming, as well as the order of a few things here, this does work if you just paste it (but NOT if you have pg_config from 9.5 installed!!). It will build against whatever version /usr/bin/pg_config points to (which by default is the most recent pg -dev package you have installed).

I've attached build output of this too.

mkdir build; cd build; apt-get source pgtap; git clone git(at)github(dot)com:theory/pgtap.git; cd pgtap-0.90.0; uupdate -v 0.95.1 ../pgtap; cd ..; mv pgtap pgtap-0.95.1; rm -rf pgtap-0.95.1/.git; tar czf pgtap_0.95.1.orig.tar.gz pgtap-0.95.1; cd pgtap-0.95.1; debuild -i -us -uc

--
Jon Erdman <jon(dot)erdman(at)bluetreble(dot)com>
Sr. Data Engineer, Blue Treble Solutions, LLC
312.285.6735

On Mon, 25 May 2015 14:07:14 -0500
Jon Erdman <jon(dot)erdman(at)bluetreble(dot)com> wrote:

>
> OBTW, here's how I made it:
>
> mkdir build; cd build; apt-get deb-src pgtap; git clone git(at)github(dot)com:theory/pgtap.git; mv pgtap pgtap-0.95-1; rm -rf pgtap-0.95-1/.git; tar czf pgtap_0.95.1.orig.tar.gz pgtap-0.95-1; uupdate -v 0.95.1 pgtap-0.95-1; cd pgtap-0.95.1; debuild -i -us -uc
>
> I made a mistake here though :( all occurrences above of the string pgtap-0.95-1 should be pgtap-0.95.1 so let me rebuild again and I'll send again.
>
> --
> Jon Erdman <jon(dot)erdman(at)bluetreble(dot)com>
> Sr. Data Engineer, Blue Treble Solutions, LLC
> 312.285.6735
>
> On Mon, 25 May 2015 13:55:18 -0500
> Jon Erdman <jon(dot)erdman(at)bluetreble(dot)com> wrote:
>
> >
> > .deb (binary-indep) built against 9.4, and deb-src attached.
> >
> > The problem here is that this package is set up to only work against one pg version at a time. We'll need to change that...probably by appending -9.x to the package version and making multiple debs :(
> >
> > Anyone have a better idea?
> > --
> > Jon Erdman <jon(dot)erdman(at)bluetreble(dot)com>
> > Sr. Data Engineer, Blue Treble Solutions, LLC
> > 312.285.6735
> >
> > On Mon, 25 May 2015 12:46:42 -0500
> > Jon Erdman <jon(dot)erdman(at)bluetreble(dot)com> wrote:
> >
> > > On Mon, 25 May 2015 12:43:40 -0500
> > > Jon Erdman <jon(dot)erdman(at)bluetreble(dot)com> wrote:
> > >
> > > > On Mon, 25 May 2015 16:18:58 +0200
> > > > Christoph Berg <myon(at)debian(dot)org> wrote:
> > > >
> > > > > Re: Jon Erdman 2015-05-24 <20150524112636(dot)83d050151cf11cec43bd7245(at)bluetreble(dot)com>
> > > > > >
> > > > > > So, in Ubuntu at least, there is only pgtap for 9.1, and this is a pain. How would you guys feel about adding it to the PGDB apt repo? Should be relatively simple since there are no binaries involved...
> > > > >
> > > > > Hi,
> > > > >
> > > > > at the moment the pgtap package is seriously broken:
> > > > >
> > > > > https://bugs.debian.org/cgi-bin/pkgreport.cgi?pkg=pgtap;dist=unstable
> > > > >
> > > > > Most notably:
> > > > >
> > > > > https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=729559
> > > > >
> > > > > One these are fixed, we can add it to the pgapt repo as well.
> > > > >
> > > > > The fix is probably simple, but someone needs to do it, and possibly
> > > > > become the new maintainer, Pierre doesn't seem to be interested atm.
> > > >
> > > > Really adding David Wheeler this time. ;)
> > > >
> > > > Took a quick look at these...I think they're all fixed if we update the source in the package to 0.95.1 (which is what's current in pgtap git repo), as that built fine for me for all pg versions I have installed from PGDG 9.1-4 and even the 9.5 I have built from git HEAD and symlinked such that it shows up in the pg_common stuff (i.e. in the output of pg_lsclusters and pg_ctlcluster can control it, etc).
> > > >
> > > > I'll try to see how much that work it would entail to move this from 0.90.0 to 0.95.1 (I suspect not much, based on previous work with deb-src packages).
> > >
> > > Here's proof 0.95.0 has that bug fixed:
> > >
> > > jon(at)stuck:~$ cd /usr/share/postgresql/9.4/extension/
> > > jon(at)stuck:/usr/share/postgresql/9.4/extension$ ll pgtap*
> > > -rw-r--r-- 1 root root 731 May 24 11:41 pgtap--0.90.0--0.91.0.sql
> > > -rw-r--r-- 1 root root 54K May 24 11:41 pgtap--0.91.0--0.92.0.sql
> > > -rw-r--r-- 1 root root 21K May 24 11:41 pgtap--0.92.0--0.93.0.sql
> > > -rw-r--r-- 1 root root 5.4K May 24 11:41 pgtap--0.93.0--0.94.0.sql
> > > -rw-r--r-- 1 root root 17K May 24 11:41 pgtap--0.94.0--0.95.0.sql
> > > -rw-r--r-- 1 root root 292K May 24 11:41 pgtap--0.95.0.sql
> > > -rw-r--r-- 1 root root 177 May 24 11:41 pgtap.control
> > > -rw-r--r-- 1 root root 113K May 24 11:41 pgtap-core--0.95.0.sql
> > > -rw-r--r-- 1 root root 179K May 24 11:41 pgtap-schema--0.95.0.sql
> > > -rw-r--r-- 1 root root 47K May 24 11:41 pgtap--unpackaged--0.91.0.sql
> > > jon(at)stuck:/usr/share/postgresql/9.4/extension$
> > >
> > > --
> > > Jon Erdman <jon(dot)erdman(at)bluetreble(dot)com>
> > > Sr. Data Engineer, Blue Treble Solutions, LLC
> > > 312.285.6735