From: dgovoni at metadapt.com (Darren Govoni)
Date: Sat, 25 Mar 2006 20:58:42 -0500
Subject: [Pljava-dev] PostgreSQL 8.1 Pljava install problem
In-Reply-To: <4425ECA6.9090709@metadapt.com>
References: <94A24C93CB808844ACB7444B3A188AB41ADC50E7@XMS.ad2.bu.edu>
	<442177FA.3010500@tada.se>
	<4425ECA6.9090709@metadapt.com>
Message-ID: <4425F552.1060703@metadapt.com>

I got it to work. One has to be extra careful the shared libraries get 
overwritten if they're installing over a prior version.

Sorry for the extra emails....

Darren

Darren Govoni wrote:
> 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
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>