Install pljava on OpenSuSE

Posted on Wed 15 June 2011 in PostgreSQL

Install SUN/Oracle JDK and PostgreSQL via zypper or Yast.

Download pljava here

Create a directory for example /usr/src/pljava and extract pljava there.

create /etc/ with this two lines in it if your using i386 cpu architecture.


now you have to run:


edit /var/lib/pgsql/data/postgresql.conf and add this two lines

custom_variable_classes = 'pljava'
pljava.classpath = '/usr/lib/postgresql/pljava.jar'

copy /usr/src/pljava/pljava.jar and /usr/src/pljava/ to /usr/lib/postgresql/

cp /usr/src/pljava/pljava.jar /usr/lib/postgresql/
cp /usr/src/pljava/ /usr/lib/postgresql/

restart postgres service:

rcpostgres restart

apply the install.sql:

su postgres -c "/usr/bin/psql -d template1 -f /usr/src/pljava/install.sql"