From: pierce at hogranch.com (John R Pierce) Date: Thu, 11 Oct 2012 16:58:00 -0700 Subject: [Pljava-dev] pljava on AIX for postgres 9.1.x and IBM AIX Java 6? In-Reply-To: <5075FE04.4020407@hogranch.com> References: <50651F8A.1080704@hogranch.com> <50660523.5050503@hogranch.com> <50660A90.3020308@hogranch.com> <5069E7C8.4090004@hogranch.com> <5073DEED.8030504@hogranch.com> <507472B6.3060100@hogranch.com> <507474C0.1010304@hogranch.com> <50749A49.8060003@hogranch.com> <5075C351.1010101@hogranch.com> <5075C9D9.9080303@ejurka.com> <5075FE04.4020407@hogranch.com> Message-ID: <50775D08.9030409@hogranch.com> On 10/10/12 4:00 PM, John R Pierce wrote: > $ echo $LD_LIBRARY_PATH > /opt/XXX/pljava:/usr/java5_64/jre/bin:/opt/pgsql91/lib slight progress here, its LIBPATH not LD_LIBRARY_PATH on AIX. sheesh. still stuck on .... $ /usr/java6_64/bin/java -cp deploy.jar:postgresql-9.2-1000.jdbc4.jar org.postgresql.pljava.deploy.Deployer -install -host 127.0.0.1 -port 5432 -user postgres -password XXXX org.postgresql.util.PSQLException: ERROR: could not load library "/opt/XXX/pljava/pljava.so": Could not load module /opt/XXX/pljava/pljava.so. Dependent module libpljava.a(pljava.so) could not be loaded. Could not load module libpljava.a(pljava.so). System error: No such file or directory Could not load module /opt/XXX/pljava/pljava.so. Dependent module /opt/XXX/pljava/pljava.so could not be loaded. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395) at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474) at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269) $ echo $LIBPATH /opt/XXX:/usr/java5_64/jre/bin $ ldd pljava.so pljava.so needs: /usr/lib/libc.a(shr_64.o) Cannot find libpljava.a(pljava.so) /usr/java5_64/jre/bin/j9vm/libjvm.a /unix /usr/lib/libcrypt.a(shr_64.o) /usr/lib/libc_r.a(shr_64.o) /usr/lib/libpthread.a(shr_xpg5_64.o) /usr/java5_64/jre/bin/libjsig.so /usr/java5_64/jre/bin/libj9thr23.so -- john r pierce N 37, W 122 santa cruz ca mid-left coast