Install SUN/Oracle JDK and PostgreSQL via zypper or Yast.
Download pljava here http://pgfoundry.org/frs/?group_id=1000038&release_id=1024
Create a directory for example /usr/src/pljava and extract pljava there.
create /etc/ld.so.conf.d/postgres.conf with this two lines in it if your using i386 cpu architecture.
/usr/lib/jvm/java/lib /usr/lib/jvm/jre/lib/i386/server
now you have to run:
ldconfig
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/pljava.so to /usr/lib/postgresql/
cp /usr/src/pljava/pljava.jar /usr/lib/postgresql/ cp /usr/src/pljava/pljava.so /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"
This work, unless otherwise expressly stated, is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
Comments 4
Excellent!! thanks!
Posted 08 Jul 2011 at 10:48 pm ¶Great blog, helped me install PLJAVA on Ubuntu LTS 10.04 with PostgreSQL 8.4.
I wrote a blog for Ubuntu LTS 10.04 based on your blog, see http://tonny-bruckers.blogspot.com/2012/05/install-pljava-postgresql-84-on-ubuntu.html.
I hope you are fine with this.
Thx
Posted 13 May 2012 at 9:42 pm ¶Hi Tonny,
yes of course i am fine with it. Nice post you wrote. Hope this will save a lot of time for some people out there.
Regards,
Dominik
Posted 13 May 2012 at 9:44 pm ¶Hello,
I am a beginner and I tried installing pljava in postgres9.2.
There are a few issues which has made my day horrible
1.I am not able to find any .so files
2.I dont find any posstgresql.conf
so instead of the edit /var/lib/pgsql/data/postgresql.conf i have edited the one from opt/psql/data
Kindly help me out…This might be a crazy question as a beginner i dont know how to proceed..thanks in advance
Posted 10 Apr 2013 at 2:43 pm ¶Post a Comment