From: johann at 2ndquadrant.com (Johann 'Myrkraverk' Oskarsson) Date: Sun, 23 Jan 2011 18:51:41 -0000 Subject: [Pljava-dev] Windows binaries In-Reply-To: <4D3C7606.5080205@gmail.com> References: <4D3A3076.4070905@gmail.com> <4D3C6777.10708@gmail.com> <4D3C6B11.3010706@gmail.com> <4D3C6F68.9060304@gmail.com> <4D3C7606.5080205@gmail.com> Message-ID: On Sun, 23 Jan 2011 18:40:06 -0000, Eric Kolotyluk 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/