From: ironjug at hotmail.com (Thomas Hallgren) Date: Fri, 01 Apr 2005 15:47:49 +0200 Subject: [Pljava-dev] java.sql.SQLException: ERROR: could not loadlibrary"/usr/local In-Reply-To: <200504011326.j31DQYnn008303@localhost.localdomain> References: <200504011326.j31DQYnn008303@localhost.localdomain> Message-ID: <424D5105.5080205@hotmail.com> 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/jre >/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