From: Brian Fehrle <brianf@consistentstate.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: creating language plperl fails in windows 7
Date: Fri, 01 Oct 2010 13:28:54 -0600
Message-ID: <4CA63676.6020106@consistentstate.com> (raw)
Hi all,
I've been tasked with getting postgresql 8.3 set up on a Windows 7
box. I have zero experience with Windows 7, and very little with Windows
in general so I'm having some trouble.
I installed postgres 8.3 using EnterpriseDB's one click installer. I
need to import a sql file I created from my linux box from a pg_dump,
which includes some functions that depend on plperl.
I log into a psql terminal and run
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.
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.
I'm not fully sure what to do here. I don't have the ability to reboot
the whole system (I hear turning it off and on again works with windows).
Thanks in advance for any help possible.
Brian F
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: brianf@consistentstate.com
Subject: Re: creating language plperl fails in windows 7
In-Reply-To: <4CA63676.6020106@consistentstate.com>
* 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