Postgres Pro
Downloads
Home   >   mailing lists

Thread: Plperl, createlang fails

Plperl, createlang fails

From
"David Kirol"
Date:
Env WinNt, latest cygwin, postgresql 7.3.1
I am trying to get the procedural language plperl up and running on a new
installation.
This new installation was, well a mistake. I allowed cygwin to install all
the packages it could and it overwrote the
previous 7.2.x. The docs tell me the following should work, but:

$ createlang plperl template1
ERROR:  Load of file /usr/lib/postgresql/plperl.dll failed: dlopen: Win32
error 126
ERROR:  Load of file /usr/lib/postgresql/plperl.dll failed: dlopen: Win32
error 126
createlang: language installation failed

Can anybody shed some light.
TIA

Re: Plperl, createlang fails

From
Jason Tishler
Date:
David,

On Mon, Jan 27, 2003 at 05:41:50PM -0500, David Kirol wrote:
> $ createlang plperl template1
> ERROR:  Load of file /usr/lib/postgresql/plperl.dll failed: dlopen: Win32
> error 126
> ERROR:  Load of file /usr/lib/postgresql/plperl.dll failed: dlopen: Win32
> error 126
> createlang: language installation failed
>
> Can anybody shed some light.

Please read the README:

    http://www.tishler.net/jason/software/postgresql/postgresql-7.3.1.README

Specifically, the following:

    The following packages or later are required to build and/or execute
    Cygwin PostgreSQL:

    [snip]
    perl 5.8.0-1

I presume that you are running perl 5.6.1-2.  If so, then rerun Cygwin's
setup.exe and install perl 5.8.0-1.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: Plperl, createlang fails

From
Jason Tishler
Date:
David,

Please keep your replies on-list.

On Tue, Jan 28, 2003 at 06:43:29PM -0500, David Kirol wrote:
>Thanks for taking the time to reply to my plea for help. I am about 50
>Watts of a 75 Watt Bulb on occasion, but I have seen RTFM too many
>times to ignore the Fine Manual (and the fine README) ;-) In this
>particular case I hit every readme that the cygwin package had and none
>of them had this information.

Really?  Did you miss...

>Can you point me to the correct docs for 7.3.1?

the following?

    /usr/doc/Cygwin/postgresql-7.3.1.README

>Also when I upgraded cygwin the nasa mirror did not have Perl 5.8.x.

It does:

    ftp://ftp.nas.nasa.gov/mirrors/cygwin.com/pub/cygwin/release/perl/perl-5.8.0-1.tar.bz2

Note that Perl 5.8.0-1 is marked test, so you will have to click on the
"spin icon" until this version is selected.

>If you know of a site that can provide it I'd be grateful.

Any Cygwin mirror should work.

> I presume that you are running perl 5.6.1-2.  If so, then rerun Cygwin's
> setup.exe and install perl 5.8.0-1. - correct!
>
> Thanks I knew it would be something easy!

You are welcome.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6