[Pljava-dev] PostgreSQL 8.1 Pljava install problem

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
>

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
>>
>>
>
>

Michael,
I made an attempt to improve the installation instructions on the Wiki.
A new version can be viewed at
http://wiki.tada.se/display/pljava/Installation+Guide. Comments are very
welcome.

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
>>
>>
>
>