agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] PostgreSQL 8.1 Pljava install problem
Date: Sat, 25 Mar 2006 20:21:42 -0500
Message-ID: <4425ECA6.9090709@metadapt.com> (raw)
In-Reply-To: <442177FA.3010500@tada.se>
References: <94A24C93CB808844ACB7444B3A188AB41ADC50E7@XMS.ad2.bu.edu>
<442177FA.3010500@tada.se>
Hi,
I was looking back on this thread because I am trying to re-install with
8.1 and pljava 1.2 on suse 9.3 desktop linux. I followed all the
instructions on the wiki. Got postgres 8.1.3 installed fine. Built
pljava 1.2.0, installed fine. Put the pljava.jar and everything in
build/objs/* into /usr/share/pljava (documentation needs clarity here).
My postmaster has jvm in path and I updated my LD_LIBRARY_PATH to
include /usr/share/pljava and did a /sbin/ldconfig.
Added the following lines to my .conf file
---
dynamic_library_path ='$libdir;/usr/share/pljava'
custom_variable_classes = 'pljava'
pljava.classpath='/usr/share/pljava.jar'
---
I get this error when running deployer:
postgres at ninja:/home/darren/postgres> java -cp
./postgresql-8.1dev-401.jdbc3.jar:pljava-1.2.0/build/deploy.jar
org.postgresql.pljava.deploy.Deployer -install
org.postgresql.util.PSQLException: ERROR: invalid macro name in dynamic
library path: $libdir;/usr/share/pljava
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1499)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1284)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:429)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:334)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:326)
at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:432)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
So I removed the $libdir part and tried again. I get:
postgres at ninja:/home/darren/postgres> java -cp
./postgresql-8.1dev-401.jdbc3.jar:pljava-1.2.0/build/deploy.jar
org.postgresql.pljava.deploy.Deployer -install
org.postgresql.util.PSQLException: ERROR: could not load library
"/usr/share/pljava/libpljava.so": /usr/share/pljava/libpljava.so:
undefined symbol: GetCurrentAbsoluteTimeUsec
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1499)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1284)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:429)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:334)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:326)
at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:432)
Any tips greatly appreciated!
Cheers,
Darren
view thread (9+ messages) latest in thread
Message-ID: <4425ECA6.9090709@metadapt.com>
Permalink: ../4425ECA6.9090709@metadapt.com/
Also on: postgresql.org/message-id/4425ECA6.9090709@metadapt.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] PostgreSQL 8.1 Pljava install problem
In-Reply-To: <4425ECA6.9090709@metadapt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox