From: thomas at tada.se (Thomas Hallgren) Date: Wed, 22 Mar 2006 17:14:50 +0100 Subject: [Pljava-dev] PostgreSQL 8.1 Pljava install problem In-Reply-To: <94A24C93CB808844ACB7444B3A188AB41ADC50E7@XMS.ad2.bu.edu> References: <94A24C93CB808844ACB7444B3A188AB41ADC50E7@XMS.ad2.bu.edu> Message-ID: <442177FA.3010500@tada.se> Shulman, Michael wrote: > Hi Thomas, > > I did successful install pljava on my computer (Windows XP) thank to > you. > But when I installed it on server (windows 2000 Sp4) I got same error. > Only deference I found is I am running Java 1.5 on my PC and java > 1.4.2_09 on server. > Can be this a problem?? > > No, that's not very likely. The same PL/Java binary can use either version. Regards, Thomas Hallgren > Michael > > -----Original Message----- > From: Thomas Hallgren [mailto:thomas at tada.se] > Sent: Wednesday, March 15, 2006 2:49 PM > To: Shulman, Michael > Cc: pljava-dev at gborg.postgresql.org > Subject: Re: [Pljava-dev] PostgreSQL 8.1 Pljava install problem > > > Michael, > Michael, > > There are two requirements that must be met: > 1. The libpljava.dll must be at the expected location. In your case > "C:/PostgreSQL_8.1/lib/libpljava.dll" > 2. The bin and bin\client directories of your JRE installation must be > in the PATH that is in effect for the postmaster backend. > > That's all there is to it. If those settings are correct, you will not > get the error. > > My guess is that you run PostgreSQL as a service and your PATH setting > is local (i.e. not visible to the postmaster service). The PATH must be > in effect for the service. I.e. you have to set it either as a System > environment setting or as an environment setting for the account that > runs that service. > > Regards, > Thomas Hallgren > > > > Shulman, Michael wrote: > >> Thank you for answer. >> I did this and got same result >> >> Best wishes, >> Michael >> >> -----Original Message----- >> From: Thomas Hallgren [mailto:thomas at tada.se] >> Sent: Wednesday, March 15, 2006 1:53 PM >> To: Shulman, Michael >> Cc: pljava-dev at gborg.postgresql.org >> Subject: Re: [Pljava-dev] PostgreSQL 8.1 Pljava install problem >> >> >> Hi Michael, >> Take a look at http://wiki.tada.se/display/pljava/Installation+Guide >> >> Pay special attention to 'Shared Object issues' and the Windows PATH >> setting (it must include two important directories from your Java >> installation). >> >> Kind regards, >> Thomas Hallgren >> >> Shulman, Michael wrote: >> >> >>> Hi >>> I have installed PostrgeSQL 8.1 with pljava. >>> When I try to run install.sql script I got this error >>> "ERROR: could not load library >>> "C:/PostgreSQL_8.1/lib/libpljava.dll": >>> The specified module could not be found." >>> Please advice >>> >>> Mike >>> _______________________________________________ >>> Pljava-dev mailing list >>> Pljava-dev at gborg.postgresql.org >>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev >>> >>> >>> >> >> > >