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’ [...]
This tutorial explains a basic configuration using PostgreSQL and CentOS. For detailed information about configuration parameter please read the PostgreSQL documentation which is very good organized. First thing you should do is updating your system to the last patch level. Be sure all the other installed software on this system works with the newest patches [...]
Most webapplications are using a database to store there information nowadays. Often MySQL is used to do this task if it’s an cost sensitive organisation or person. MySQL is easy to install and manage in small environments but if you have many transactions and higher load on your database you should know how to speed [...]
