[Pljava-dev] Pl/Java package in Ubuntu

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>
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) 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
> Fax : +1 520 621 8229
> Email: p.brewer at ltrr.arizona.edu
> Web : http://ltrr.arizona.edu
> *********************************
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at lists.pgfoundry.org
> http://lists.pgfoundry.org/mailman/listinfo/pljava-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20150908/b5d2a54e/attachment.html>