> 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.