[Pljava-dev] building pljava for solaris 10 sparc 64bit

Kris Jurka wrote:
> On Thu, 15 Apr 2010, John R Pierce wrote:
> (... pl/java HEAD building on sparc 64bit solaris, pg8.4.3, jdk
> 1.5.0_23....)
>> this script is setting PGBIN, PGDATA, and PGLOG before running
>> pg_ctl, so I am pretty sure its already in the target user. yes,
>> indeed, SMF has a service property "method_context/user astring
>> postgres" which specifies what user to run the start method as, so
>> its looking like changing the user is done -before- running this script.
>
> Perhaps you need to export those variables:
>
> export LD_LIBRARY_PATH

duh, I should have thought of that...
all reet... that got me to a NEW error :-) [the fun never ends!]

$ java org.postgresql.pljava.deploy.Deployer -install -password XXXXXX
org.postgresql.util.PSQLException: ERROR: could not load library
"/opt/FIS/pljava/pljava.so": ld.so.1: postgres: fatal: relocation error:
file /opt/FIS/pljava/pljava.so: symbol Int64GetDatum: referenced symbol
not found
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:332)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:324)
at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)

with the same environment stuff set in my shell, that .so seems to pass
ldd just fine.

$ ldd /opt/FIS/pljava/pljava.so
libjvm.so =>
/usr/jdk/jdk1.5.0_23/jre/lib/sparcv9/server/libjvm.so
libsocket.so.1 => /lib/64/libsocket.so.1
libsched.so.1 => /usr/lib/64/libsched.so.1
libdl.so.1 => /lib/64/libdl.so.1
libCrun.so.1 => /usr/lib/64/libCrun.so.1
libm.so.1 => /lib/64/libm.so.1
libthread.so.1 => /lib/64/libthread.so.1
libc.so.1 => /lib/64/libc.so.1
libnsl.so.1 => /lib/64/libnsl.so.1
libmp.so.2 => /lib/64/libmp.so.2
libmd.so.1 => /lib/64/libmd.so.1
libscf.so.1 => /lib/64/libscf.so.1
libdoor.so.1 => /lib/64/libdoor.so.1
libuutil.so.1 => /lib/64/libuutil.so.1
libgen.so.1 => /lib/64/libgen.so.1
libm.so.2 => /lib/64/libm.so.2
/platform/SUNW,Sun-Fire-V490/lib/sparcv9/libc_psr.so.1
/platform/SUNW,Sun-Fire-V490/lib/sparcv9/libmd_psr.so.1