From: Christian Ullrich <chris@chrullrich.net>
To: pgsql-admin@postgresql.org
Subject: Re: creating language plperl fails in windows 7
Date: Sat, 02 Oct 2010 07:46:20 +0200
Message-ID: <i86gv6$14d$1@dough.gmane.org> (raw)
In-Reply-To: <4CA63676.6020106@consistentstate.com>
References: <4CA63676.6020106@consistentstate.com>
* Brian Fehrle wrote:
> CREATE LANGUAGE plperl;
> ERROR: could not load library "C:/Program Files
> (x86)/PostgreSQL/8.3/lib/plperl.dll": The specified module could not be
> found.
>
> I looked in that location and the plperl.dll does exist. I checked
> permissions, both the user account postgres and the user account I'm
> logged into windows have permissions on it.
You're missing some DLL that's used by plperl.dll, most likely one from
the Perl installation itself.
> I then realized I did not have perl installed, so I installed
> ActivePerl, verified that the perl command works for the postgres user,
> restarted the Postgres cluster, and tried the create language plperl
> again, but I get the same error.
- Do you have the correct perl version installed? plperl.dll from the
8.3.11 installer requires Perl 5.8.
- Is the "bin" directory of the Perl installation in the PATH of the
postgres service user? You wrote that you verified the command works,
but you didn't indicate if you had to specify the full path.
--
Christian
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: chris@chrullrich.net
Subject: Re: creating language plperl fails in windows 7
In-Reply-To: <i86gv6$14d$1@dough.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox