From: pierce at hogranch.com (John R Pierce)
Date: Sun, 23 Jan 2011 15:13:39 -0800
Subject: [Pljava-dev] Windows binaries
In-Reply-To: <4D3CB385.6010403@gmail.com>
References: <C1A6B6FC8196CF43B9B4D0D2C63BFA5A18C4E39967@SPR3V9.office.local>
	<4D3A3076.4070905@gmail.com>	<op.vporvh2cuxs6vk@asuka>
	<COL116-W28471A0A9040F98339CD80D3FB0@phx.gbl>	<4D3C6777.10708@gmail.com>
	<op.vprvlq0cuxs6vk@asuka>	<4D3C6B11.3010706@gmail.com>
	<op.vprv75equxs6vk@asuka>	<4D3C6F68.9060304@gmail.com>
	<op.vprxbo05uxs6vk@asuka>	<4D3C7606.5080205@gmail.com>
	<op.vpryofceuxs6vk@asuka>	<4D3C7E10.7080906@gmail.com>
	<op.vpr0nfoauxs6vk@asuka>	<4D3CA4BD.3010206@gmail.com>
	<op.vpr76nenuxs6vk@asuka>
	<4D3CAF3D.2060802@hogranch.com> <4D3CB385.6010403@gmail.com>
Message-ID: <4D3CB623.2060409@hogranch.com>

On 01/23/11 3:02 PM, Eric Kolotyluk wrote:
>
> OK, I tried both 'C:/postgres/pljava.dll' and '/postgres/pljava.dll' 
> in the install.sql file and I get the same error message.
>
> C:\Program Files (x86)\PostgresPlus\9.0SS\share\pljava>psql -f 
> install.sql
> Password:
> CREATE SCHEMA
> GRANT
> psql:install.sql:6: ERROR:  could not load library 
> "/postgres/pljava.dll": The specified module could not be found.
>
> I also used
>
> dynamic_library_path = 'C:/postgres;$libdir'
>
> in the config file and I still get the same message.
>
> Could it be that pljava.dll is just not a proper DLL file?

or perhaps the postgres server user doesn't have 'execute' access to 
that specific file ?   check its access rights with (windows cmd)

     cacl \postgres\pljava.dll


it should look something like...

C:\postgres\pljava.dll BUILTIN\Administrators:F
                                NT AUTHORITY\SYSTEM:F
                                BUILTIN\Users:R

and you should verify that Postgres is a member of Users (via Local 
Users and Groups, in Windows control panel -> admin tools -> computer 
management)