From: bgiles at coyotesong.com (Bear Giles) Date: Tue, 8 Sep 2015 13:42:31 -0600 Subject: [Pljava-dev] Pl/Java package in Ubuntu In-Reply-To: <55EF30D4.8070508@ltrr.arizona.edu> References: <55EF30D4.8070508@ltrr.arizona.edu> Message-ID: 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 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: