agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] PostgreSQL 8.1 Pljava install problem
9+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] PostgreSQL 8.1 Pljava install problem
@ 2006-03-15 17:56
0 siblings, 1 reply; 9+ messages in thread
From: @ 2006-03-15 17:56 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] PostgreSQL 8.1 Pljava install problem
@ 2006-03-15 18:53
parent:
0 siblings, 0 replies; 9+ messages in thread
From: @ 2006-03-15 18:53 UTC (permalink / raw)
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
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] PostgreSQL 8.1 Pljava install problem
@ 2006-03-15 19:24
0 siblings, 2 replies; 9+ messages in thread
From: @ 2006-03-15 19:24 UTC (permalink / raw)
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
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] PostgreSQL 8.1 Pljava install problem
@ 2006-03-15 19:49
parent:
1 sibling, 0 replies; 9+ messages in thread
From: @ 2006-03-15 19:49 UTC (permalink / raw)
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
>>
>>
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] PostgreSQL 8.1 Pljava install problem
@ 2006-03-15 21:36
parent:
1 sibling, 0 replies; 9+ messages in thread
From: @ 2006-03-15 21:36 UTC (permalink / raw)
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
>>
>>
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] PostgreSQL 8.1 Pljava install problem
@ 2006-03-22 15:27
0 siblings, 1 reply; 9+ messages in thread
From: @ 2006-03-22 15:27 UTC (permalink / raw)
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??
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
>>
>>
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] PostgreSQL 8.1 Pljava install problem
@ 2006-03-22 16:14
parent:
0 siblings, 1 reply; 9+ messages in thread
From: @ 2006-03-22 16:14 UTC (permalink / raw)
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
>>>
>>>
>>>
>>
>>
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] PostgreSQL 8.1 Pljava install problem
@ 2006-03-26 01:21
parent:
0 siblings, 1 reply; 9+ messages in thread
From: @ 2006-03-26 01:21 UTC (permalink / raw)
Hi,
I was looking back on this thread because I am trying to re-install with
8.1 and pljava 1.2 on suse 9.3 desktop linux. I followed all the
instructions on the wiki. Got postgres 8.1.3 installed fine. Built
pljava 1.2.0, installed fine. Put the pljava.jar and everything in
build/objs/* into /usr/share/pljava (documentation needs clarity here).
My postmaster has jvm in path and I updated my LD_LIBRARY_PATH to
include /usr/share/pljava and did a /sbin/ldconfig.
Added the following lines to my .conf file
---
dynamic_library_path ='$libdir;/usr/share/pljava'
custom_variable_classes = 'pljava'
pljava.classpath='/usr/share/pljava.jar'
---
I get this error when running deployer:
postgres at ninja:/home/darren/postgres> java -cp
./postgresql-8.1dev-401.jdbc3.jar:pljava-1.2.0/build/deploy.jar
org.postgresql.pljava.deploy.Deployer -install
org.postgresql.util.PSQLException: ERROR: invalid macro name in dynamic
library path: $libdir;/usr/share/pljava
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1499)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1284)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:429)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:334)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:326)
at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:432)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
So I removed the $libdir part and tried again. I get:
postgres at ninja:/home/darren/postgres> java -cp
./postgresql-8.1dev-401.jdbc3.jar:pljava-1.2.0/build/deploy.jar
org.postgresql.pljava.deploy.Deployer -install
org.postgresql.util.PSQLException: ERROR: could not load library
"/usr/share/pljava/libpljava.so": /usr/share/pljava/libpljava.so:
undefined symbol: GetCurrentAbsoluteTimeUsec
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1499)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1284)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:429)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:334)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:326)
at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:432)
Any tips greatly appreciated!
Cheers,
Darren
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] PostgreSQL 8.1 Pljava install problem
@ 2006-03-26 01:58
parent:
0 siblings, 0 replies; 9+ messages in thread
From: @ 2006-03-26 01:58 UTC (permalink / raw)
I got it to work. One has to be extra careful the shared libraries get
overwritten if they're installing over a prior version.
Sorry for the extra emails....
Darren
Darren Govoni wrote:
> Hi,
> I was looking back on this thread because I am trying to re-install with
> 8.1 and pljava 1.2 on suse 9.3 desktop linux. I followed all the
> instructions on the wiki. Got postgres 8.1.3 installed fine. Built
> pljava 1.2.0, installed fine. Put the pljava.jar and everything in
> build/objs/* into /usr/share/pljava (documentation needs clarity here).
> My postmaster has jvm in path and I updated my LD_LIBRARY_PATH to
> include /usr/share/pljava and did a /sbin/ldconfig.
>
> Added the following lines to my .conf file
> ---
> dynamic_library_path ='$libdir;/usr/share/pljava'
>
> custom_variable_classes = 'pljava'
> pljava.classpath='/usr/share/pljava.jar'
> ---
>
> I get this error when running deployer:
>
> postgres at ninja:/home/darren/postgres> java -cp
> ./postgresql-8.1dev-401.jdbc3.jar:pljava-1.2.0/build/deploy.jar
> org.postgresql.pljava.deploy.Deployer -install
> org.postgresql.util.PSQLException: ERROR: invalid macro name in dynamic
> library path: $libdir;/usr/share/pljava
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1499)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1284)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:429)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:334)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:326)
> at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:432)
> at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
>
> So I removed the $libdir part and tried again. I get:
>
> postgres at ninja:/home/darren/postgres> java -cp
> ./postgresql-8.1dev-401.jdbc3.jar:pljava-1.2.0/build/deploy.jar
> org.postgresql.pljava.deploy.Deployer -install
> org.postgresql.util.PSQLException: ERROR: could not load library
> "/usr/share/pljava/libpljava.so": /usr/share/pljava/libpljava.so:
> undefined symbol: GetCurrentAbsoluteTimeUsec
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1499)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1284)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:429)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:334)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:326)
> at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:432)
>
>
> Any tips greatly appreciated!
>
> Cheers,
> Darren
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2006-03-26 01:58 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-15 17:56 [Pljava-dev] PostgreSQL 8.1 Pljava install problem
2006-03-15 18:53 `
2006-03-15 19:24 [Pljava-dev] PostgreSQL 8.1 Pljava install problem
2006-03-15 19:49 `
2006-03-15 21:36 `
2006-03-22 15:27 [Pljava-dev] PostgreSQL 8.1 Pljava install problem
2006-03-22 16:14 `
2006-03-26 01:21 `
2006-03-26 01:58 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox