[Pljava-dev] Pl/Java package in Ubuntu

Thanks for the recap Bear.

I checked the PLJava archives after I sent my email I reminded myself
that I sent out a pretty similar email in 2010 with regard support for
PLJava with PG8.4! As you point out the tool chain could do with
rewriting to make building newer versions simpler and quicker so that
we're not back at this point again in 2020. :-)

It's great that PLJava has moved to Maven. There are of course Maven
plugins for generating debian (and rpm) packages which are pretty simple
to use. I've used Maven to do single click builds for Windows, OSX,
Debian/Ubuntu and Redhat for a couple of years now. I'd be happy to
lend a hand but I fear I'd be way out of my depth with the actual pljava
stuff - especially your point 7 below.

Anyone else out there fancy giving their second or third opinion?

Thanks

Peter

On 09/08/2015 12:42 PM, Bear Giles wrote:
> I looked at that recently so let me try to recap...
>
> 1. 12.04 required the GNU "gcj" compiler. That compiler was never
> widely used and further development stopped a long time ago.
>
> 2. You can build pl/java yourself now using the 'maven' tool chain. I
> think the wiki was just updated on how to do that.
>
> 3. The Debian/Ubuntu package is built around the GNU tool chain. It
> would need a rewrite today.
>
> 4. (I haven't done Debian/Ubuntu packaging for a long time so my
> knowledge on how to build modern packages is stale.)
>
> 5. There is a way to package an existing deployment - you create a
> directory with all of the files you want, run the tool, and it
> produces the .deb file. That's probably your best bet - build systems
> for 32- and 64-bit systems and then bundle them up. I don't know the
> name of the tool, just that it undoubtedly starts with "deb". :-)
>
> 6. You can use init scripts to autoinstall (and autoremove) pl/java in
> the database
>
> 7. But you also need to edit /etc/postgresql/9.x/main/postgresql.conf
> (iirc). Editing conf files programmatically is always iffy - you'll
> need them to do that themselves unless you are absolutely certain you
> know their configuration. (hint: you don't.)
>
> 8. Finally get a second or third opinion. I had to scratch an itch a
> few months ago so I asked many of these questions but there's no
> guarantee that I understood the answers.
>
> HTH,
>
> Bear
>
>
> On Tue, Sep 8, 2015 at 1:02 PM, Peter Brewer
> <p.brewer at ltrr.arizona.edu <mailto:p.brewer at ltrr.arizona.edu>> wrote:
>
> Hi all,
>
> I'm one of those leeches that uses PL/Java but doesn't have the
> expertise to contribute directly. So first of all, thanks for the
> great work!
>
> I'm the lead developer for a scientific server/client database
> application (www.tellervo.org <http://www.tellervo.org>) that uses
> PL/Java. The server portion is distributed as an Ubuntu package
> and used by a number of labs around the world. The average user of
> my product is therefore a scientist rather than hard core techie.
> As such I need to give them a package that can be easily installed
> and configured without them getting their hands dirty.
>
> My last release was aimed at Ubuntu 12.04 LTS and worked fine as
> Postgres 9.1 and compatible pljava packages were available in the
> main repos.
>
> I'm now looking at releasing the next version but see that pljava
> has been removed from the Debian repository primarily to 64 bit
> issues:
> https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=743364
>
> There is currently a pljava package for PG9.3 in the Ubuntu 14.04
> repositories but once installed even on 32bit OS it fails to run
> with the following error:
> ERROR: could not load library
> "/usr/lib/postgresql/9.3/lib/pljava.so":
> /usr/lib/postgresql/9.3/lib/pljava.so: undefined symbol:
> HeapTupleGetOid
>
> So in summary, pljava won't work "out-of-the-box" on Ubuntu beyond
> 12.04 and with the end-of-life date rapidly approaching I'm
> beginning to panic a bit!
>
> Is anyone working on this? Are there substantial technical issues
> that need solving or is it just a matter of the packaging? A PPA
> package for 32bit pljava PG9.3 would be great or even a roadmap as
> to when such a package might be available!
>
> Many thanks
>
> Peter
>
> --
> *********************************
> Dr Peter Brewer
> Research Associate
> Rm 405, Bryant Bannister Building
> Laboratory of Tree-Ring Research
> 1215 E Lowell St
> Tucson AZ 85721
> USA
> Phone: +1 520 621 0753 <tel:%2B1%20520%20621%200753>
> Fax : +1 520 621 8229 <tel:%2B1%20520%20621%208229>
> Email: p.brewer at ltrr.arizona.edu <mailto:p.brewer at ltrr.arizona.edu>
> Web : http://ltrr.arizona.edu
> *********************************
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at lists.pgfoundry.org <mailto:Pljava-dev at lists.pgfoundry.org>
> http://lists.pgfoundry.org/mailman/listinfo/pljava-dev
>
>

--
*********************************
Dr Peter Brewer
Research Associate
Rm 405, Bryant Bannister Building
Laboratory of Tree-Ring Research
1215 E Lowell St
Tucson AZ 85721
USA
Phone: +1 520 621 0753
Fax : +1 520 621 8229
Email: p.brewer at ltrr.arizona.edu
Web : http://ltrr.arizona.edu
*********************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20150908/4e1b305e/attachment.html>