From: gulden at portugalmail.pt (Gulden)
Date: Fri, 1 Apr 2005 15:06:55 +0100
Subject: [Pljava-dev] java.sql.SQLException: ERROR: could
	not	loadlibrary"/usr/local
In-Reply-To: <424D5105.5080205@hotmail.com>
Message-ID: <200504011405.j31E5lnn010379@localhost.localdomain>

Removing the trailing '/' is not the solution.

Could be the problem be related with the way the postresql were
"compiled"!!!
I've installed postgresql with the RPM's from postgresql.org

 

-----Original Message-----
From: Thomas Hallgren [mailto:ironjug at hotmail.com] 
Sent: sexta-feira, 1 de Abril de 2005 13:48
To: Gulden
Cc: 'Filip Hrbek'; 'Antonio Carlos de Andrade Brito';
pljava-dev at gborg.postgresql.org
Subject: Re: [Pljava-dev] java.sql.SQLException: ERROR: could not
loadlibrary"/usr/local

Gulden wrote:

>How can i do that?
>
>In one experience I've put this line in the /etc/init.d/postgres file
>
>export
>LD_LIBRARY_PATH=/usr/java/j2sdk1.4.1_02/jre/lib/:/usr/java/j2sdk1.4.1_02/jr
e
>/lib/i386/client/:/usr/java/j2sdk1.4.1_02/jre/lib/i386/native_threads/
>
>and it didn't solve the problem.
>  
>
Well, this is the one and only place where the LD_LIBRARY_PATH should be 
set. The client doesn't need it and there's no point in including the 
jvm in the dynamic_library_path in postgresql.conf either (it's sole 
purpose is to find the postgresql module, the dynamic loader will never 
see it). So make sure this setting is in place and that it is correct. I 
suggest you try removing the trailing '/' from all path's. You don't 
need them.

Regards,
Thomas Hallgren