[Pljava-dev] Pl/Java Installation Help Needed

From: kooifeispam at hotmail(dot)com (kooifei)
To:
Subject: [Pljava-dev] Pl/Java Installation Help Needed
Date: 2009-02-09 02:26:38
Message-ID: 21906163.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev


Hi

I carried out the following steps for PL/Java installation for my Postgresql
8.3.5 but still could not complete the installation.
1) Download pljava-x86_64-unknown-linux-gnu-pg8.1-1.4.0.tar.gz from
pgfoundry.org
2) Unpack the PL/java tarball into "/home/sadm/pljava"
3) Moved the call handler into cluster using:
$ mv pljava.so /usrlocal/pgsql/lib
$ mv pljava.jar /usrlocal/pgsql/lib
4) Edit the postgresql.conf in my $PGDATA file (add the following entries):
custom_variable_classes ='pljava'
pljava.classpath = '/usrlocal/pgsql/lib/pljava.jar'
5) Start the postmaster
6) Install using: /pljava$ java -cp
deploy.jar:/home/sadm/postgresql-8.3-604.jdbc
3.jar org.postgresql.pljava.deploy.Deployer -install -user sadm -database
mydb -
password 8clfibp2

Error message:
org.postgresql.util.PSQLException: ERROR: could not load library
"/usrlocal/pgsql/lib/pljava.so": ld.so.1: postgres: fatal:
/usrlocal/pgsql/lib/pljava.so: wrong ELF class: ELFCLASS64
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)

Can someone please help troubleshoot?

Thanks!
--
View this message in context: http://www.nabble.com/Pl-Java-Installation-Help-Needed-tp21906163p21906163.html
Sent from the PL/Java mailing list archive at Nabble.com.

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Kris Jurka 2009-02-09 04:34:30 [Pljava-dev] Pl/Java Installation Help Needed
Previous Message Edwin Ramirez 2009-01-28 15:19:53 [Pljava-dev] Array Support