From: books at ejurka.com (Kris Jurka)
Date: Sat, 19 Apr 2008 18:21:10 -0400 (EDT)
Subject: [Pljava-dev] install problems
In-Reply-To: <1208327051.29448.4.camel@ac.coralms.com>
References: <1208327051.29448.4.camel@ac.coralms.com>
Message-ID: <Pine.BSO.4.64.0804191812420.6450@leary.csoft.net>



On Wed, 16 Apr 2008, Christopher Snow wrote:

> Deployer is failing on the following call.  Any ideas?
>
> CREATE FUNCTION sqlj.java_call_handler()
> RETURNS language_handler
> AS 'pljava'
> LANGUAGE C
>
> ERROR: could not access file "pljava": No such file or directory
>
> dynamic_library_path =
> '$libdir:/home/snowch/Apps/pljava-i686-pc-linux-gnu-pg8.3-1.4.0'

Is there any chance your home directory isn't accessible to the user the 
postgresql server is running as?  That would explain why it couldn't load 
the file.

Also there is additional dynamic library loading information available at 
the debug3 level of log_min_messages.  This will likely produce a lot of 
debug information, but may point to the problem.

Kris Jurka