This is the mail archive of the cygwin@cygwin.com mailing list for the Cygwin project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Problem with PostgreSQL: createlang plperl


Hi,
I tried to install languages into PostgreSQL 7.4.1-2 and ran into the following problem:
 $ createlang plperl
 createlang: language installation failed: ERROR:  could not load library "/usr/lib/postgresql/plperl.dll": dlopen: Win32 error 126

By checking plperl.dll I noticed, that cygperl5_8_0.dll was missing:
 $ cygcheck /usr/lib/postgresql/plperl.dll
 D:/cygwin/lib/postgresql/plperl.dll
   .\postgres.exe
     .\cygcrypto-0.9.7.dll
       .\cygwin1.dll
         C:\windows\System32\KERNEL32.dll
           C:\windows\System32\ntdll.dll
     .\cygcygipc-2.dll
     .\cygssl-0.9.7.dll
 Error: could not find cygperl5_8_0.dll

perl was already installed, but with wrong version (5.8.2-1):
 $ ls /usr/bin/cygperl*
 /usr/bin/cygperl5_8_2.dll

Searched the web but couldn't find an archived perl-5.8.0 package, so I tried to make postgres (tail of logfile):
 make -C pl all
 make[2]: Entering directory `/usr/src/postgresql-7.4.1-2/src/pl'
 make[3]: Entering directory `/usr/src/postgresql-7.4.1-2/src/pl/plpgsql'
 make -C src all
 make[4]: Entering directory `/usr/src/postgresql-7.4.1-2/src/pl/plpgsql/src'
 make[4]: Nothing to be done for `all'.
 make[4]: Leaving directory `/usr/src/postgresql-7.4.1-2/src/pl/plpgsql/src'
 make[3]: Leaving directory `/usr/src/postgresql-7.4.1-2/src/pl/plpgsql'
 make[3]: Entering directory `/usr/src/postgresql-7.4.1-2/src/pl/plperl'
 
 *** Cannot build PL/Perl because libperl is not a shared library.
 *** You might have to rebuild your Perl installation.  Refer to
 *** the documentation for details.
 
 make[3]: Leaving directory `/usr/src/postgresql-7.4.1-2/src/pl/plperl'
 make[3]: Entering directory `/usr/src/postgresql-7.4.1-2/src/pl/plpython'
 
 *** Cannot build PL/Python because libpython is not a shared library.
 *** You might have to rebuild your Python installation.  Refer to
 *** the documentation for details.
 
 make[3]: Leaving directory `/usr/src/postgresql-7.4.1-2/src/pl/plpython'
 make[2]: Leaving directory `/usr/src/postgresql-7.4.1-2/src/pl'
 make[1]: Leaving directory `/usr/src/postgresql-7.4.1-2/src'
 All of PostgreSQL successfully made. Ready to install.

If I did not misunderstand the doc (http://www.perldoc.com/perl5.8.0/README.cygwin.html), libperl is a shared library by default in cygwin environment, and instead of the message which also indicates 'You might have to rebuild your Python installation', plpython runs perfectly well.

Has by chance anyone already solved this problem?

Regards

Juergen

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]