Re: Need your help (frustrating issue) - Mailing list pgsql-admin

From fred@redhotpenguin.com
Subject Re: Need your help (frustrating issue)
Date
Msg-id 37630.127.0.0.1.1069725187.squirrel@127.0.0.1
Whole thread Raw
In response to Re: Need your help (frustrating issue)  ("Siddharth Rath (sirath)" <sirath@cisco.com>)
List 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.

pgsql-admin by date:

Previous
From: "washirv"
Date:
Subject: Re: Associating client PIDs with backend PIDs
Next
From: Rob Fielding
Date:
Subject: ERROR: pltcl: Cache lookup for attribute