Table of Contents Previous Next


10 PL/Java : 10.2 Installing PL/Java on Windows

Step 1: Edit the postgresql.conf file and add (or modify) the following settings:
pljava.classpath = 'POSTGRES_INSTALL_HOME\lib\pljava.jar'
pljava.libjvm_location = 'path_to_libjvm.so'
Where POSTGRES_INSTALL_HOME specifies the location of the Advanced Server installation. For example, the following is the configuration setting for a default installation:
Step 2: Restart the database server.
Step 3: Modify the PATH setting used by the server, adding the following two entries:
%JRE_HOME%\bin;%JRE_HOME%\bin\client
Where JRE_HOME specifies the installation directory of your Java runtime environment. If you have a Java development kit, substitute the location of $JDK_HOME/jre for JRE_HOME.
Step 4: Use the Postgres CREATE EXTENSION command to install PL/Java. To run the installation script, use the psql or pgAdmin client to connect to the database in which you wish to install PL/Java and invoke the following command:
Step 5: To confirm that PL/Java is installed, invoke the following command:

10 PL/Java : 10.2 Installing PL/Java on Windows

Table of Contents Previous Next