Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group