Re: Need your help (frustrating issue)

From: fred(at)redhotpenguin(dot)com
To: sirath(at)cisco(dot)com
Cc: fred(at)redhotpenguin(dot)com, "'Matt Davies'" <matt(at)mattdavies(dot)net>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Need your help (frustrating issue)
Date: 2003-11-25 01:53:07
Message-ID: 37630.127.0.0.1.1069725187.squirrel@127.0.0.1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> Hi Fred/Matt,
> I'm still stuck-up at the same issue
> (/apps/systran/perl/lib/sun4-solaris/auto/DBD/Pg/Pg.so' for module
> DBD::Pg: ld.so.1: /usr/local/bin/perl: fatal: libgcc_s.so.1: open
> failed: No such file or directory at
> /usr/local/perl5.6.1/lib/sun4-solaris/DynaLoader.pm line 206.
> at (eval 1) line 3) .
>
> I did get the following mesg while deploying the POSTGRESQL server.
> *** 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.
> It will' be really great if you please let me know whether I'm facing
> the issue coz libperl is not shared library?
<snip>

It looks like you'll need to rebuild perl with the shared library option
enabled to enable it's use by PL/Perl. The first message references
/usr/local/bin/perl so I'm assuming the superuser did a source install of
5.6.1 with the default options. I suggest you install perl from source in
your /apps/systran/ directory and enable the option to build a shared
libperl. Once you do that add /apps/systran/perl/bin to your PATH and
open/refresh your shell.

After you have this installed, type 'perl -V' and you should see
/apps/systran/perl/... several times in the @INC array, and also the
command 'which perl' should return /apps/systran/perl/bin/perl. Now
re-install DBD::Pg - since you are using /apps/systran/perl/bin/perl you
don't need to specify a prefix, it will be installed under the
/apps/systran tree. This should take care of the DynaLoader error.

Now build Postgres again and you should be all good - you have your own
custom perl application and library that other system users won't
accidentally squash. Here's a good reference link to getting your own
perl apps/libraries installed.

http://www.perl.com/pub/a/2002/04/10/mod_perl.html

Feel free to bounce any perl installation questions at me off the list -
this procedure should take care of the dependencies and get you going.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Iain 2003-11-25 05:30:47 A quick question about domains
Previous Message washirv 2003-11-25 00:30:34 Re: Associating client PIDs with backend PIDs