[Pljava-dev] Windows binaries

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)