[Pljava-dev] Windows binaries

On Sun, 23 Jan 2011 18:40:06 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:

> Sorry, please bear with me, I am new to PostgreSQL as I am evaluating it
> for possible use, so nothing is familiar.
>
> In my postgresql.conf file I have
>
> #dynamic_library_path = '$libdir'
>
> So would I change it to something like
>
> #dynamic_library_path = '$libdir;c:\postgres'

Yes, assuming you've moved the pljava.dll to c:\postgres. The you just
have to uncomment it by removing the #.

dynamic_library_path = '$libdir;c:\postgres'

> I do not know how to confirm

After this change it's probably best to restart the server. If you used
pg_ctl to start it you can use the restart command, or stop and then
start. See the reference for pg_ctl for the details.

> "Also make sure your JVM dll is in the path of your server process."

As long as JVM.DLL (or maybe LIBJVM.DLL) is in your path, such as in
either %JAVA_HOME%\jre\bin or %JAVA_HOME%\jre\bin\client you'll be fine.

> Also, per the instructions I added the following to my postgresql.conf
> file earlier - is this correct?

Everything seems fine to me.

> pljava.classpath = 'C:\Program Files
> (x86)\PostgresPlus\9.0SS\PostGIS\java\pljava\postgis_pljava.jar'

Perhaps it's worthwhile to set this to a path without spaces as well.

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/