Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id BB1DC1337B43 for ; Sat, 2 Oct 2010 02:46:32 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 76088-09 for ; Sat, 2 Oct 2010 05:46:26 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from lo.gmane.org (lo.gmane.org [80.91.229.12]) by mail.postgresql.org (Postfix) with ESMTP id 7BB52133729E for ; Sat, 2 Oct 2010 02:46:25 -0300 (ADT) Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1P1uvP-0006dK-KZ for pgsql-admin@postgresql.org; Sat, 02 Oct 2010 07:46:23 +0200 Received: from p54a664a4.dip.t-dialin.net ([84.166.100.164]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 02 Oct 2010 07:46:23 +0200 Received: from chris by p54a664a4.dip.t-dialin.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 02 Oct 2010 07:46:23 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Christian Ullrich Subject: Re: creating language plperl fails in windows 7 Date: Sat, 02 Oct 2010 07:46:20 +0200 Lines: 28 Message-ID: References: <4CA63676.6020106@consistentstate.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: p54a664a4.dip.t-dialin.net User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.2.9) Gecko/20100915 Thunderbird/3.1.4 In-Reply-To: <4CA63676.6020106@consistentstate.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201010/21 X-Sequence-Number: 35762 * 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