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

Here you go. Included everyone on the other message rather than just you, just in case there had been other additions
thathadn't seen this one. 
--
Jon Erdman <jon.erdman@bluetreble.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.erdman@bluetreble.com>
To: Jon Erdman <jon.erdman@bluetreble.com>
Cc: Christoph Berg <myon@debian.org>, David Wheeler <david@justatheory.com>, Dimitri Fontaine <dimitri@2ndquadrant.fr>,
MagnusHagander <magnus@hagander.net>, Jim Nasby <Jim.Nasby@BlueTreble.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
youhave pg_config from 9.5 installed!!). It will build against whatever version /usr/bin/pg_config points to (which by
defaultis 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@github.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;
cdpgtap-0.95.1; debuild -i -us -uc 

--
Jon Erdman <jon.erdman@bluetreble.com>
Sr. Data Engineer, Blue Treble Solutions, LLC
312.285.6735

On Mon, 25 May 2015 14:07:14 -0500
Jon Erdman <jon.erdman@bluetreble.com> wrote:

>
> OBTW, here's how I made it:
>
> mkdir build; cd build; apt-get deb-src pgtap; git clone git@github.com:theory/pgtap.git; mv pgtap pgtap-0.95-1; rm
-rfpgtap-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
rebuildagain and I'll send again. 
>
> --
> Jon Erdman <jon.erdman@bluetreble.com>
> Sr. Data Engineer, Blue Treble Solutions, LLC
> 312.285.6735
>
> On Mon, 25 May 2015 13:55:18 -0500
> Jon Erdman <jon.erdman@bluetreble.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...probablyby appending -9.x to the package version and making multiple debs :( 
> >
> > Anyone have a better idea?
> > --
> > Jon Erdman <jon.erdman@bluetreble.com>
> > Sr. Data Engineer, Blue Treble Solutions, LLC
> > 312.285.6735
> >
> > On Mon, 25 May 2015 12:46:42 -0500
> > Jon Erdman <jon.erdman@bluetreble.com> wrote:
> >
> > > On Mon, 25 May 2015 12:43:40 -0500
> > > Jon Erdman <jon.erdman@bluetreble.com> wrote:
> > >
> > > > On Mon, 25 May 2015 16:18:58 +0200
> > > > Christoph Berg <myon@debian.org> wrote:
> > > >
> > > > > Re: Jon Erdman 2015-05-24 <20150524112636.83d050151cf11cec43bd7245@bluetreble.com>
> > > > > >
> > > > > > So, in Ubuntu at least, there is only pgtap for 9.1, and this is a pain. How would you guys feel about
addingit 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
iswhat'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
eventhe 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
ofpg_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,
basedon previous work with deb-src packages). 
> > >
> > > Here's proof 0.95.0 has that bug fixed:
> > >
> > > jon@stuck:~$ cd /usr/share/postgresql/9.4/extension/
> > > jon@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@stuck:/usr/share/postgresql/9.4/extension$
> > >
> > > --
> > > Jon Erdman <jon.erdman@bluetreble.com>
> > > Sr. Data Engineer, Blue Treble Solutions, LLC
> > > 312.285.6735