Re: problem installing DBD::Pg

On Wed, 4 Oct 2006, Vince Daneff wrote:

> Hi dbd-pg,
>
> I have problem installing DBD::Pg and this is my output:
>
> Running make test
> PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
> t/00-signature......WARNING: This key is not certified with a trusted signature!
> Primary key fingerprint: 2529 DF6A B8F7 9407 E944  45B4 BC9B 9067 1496 4AC8
> t/00-signature......ok
> t/00basic...........NOK 2#     Failed test (t/00basic.t at line 11)
> #     Tried to use 'DBD::Pg'.
> #     Error:  Can't load '/usr/.cpan/build/DBD-Pg-1.49/blib/arch/auto/DBD/Pg/Pg.so' for module DBD::Pg: libpq.so.4: cannot open shared object file:
> No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.

It looks like libpq.so.4 is not in your standard libpath.  I've had 
success fixing this error in the past with the following steps:

1) figure out where libpq.so.4 is located (probably /usr/something/lib)
2) add that path to /etc/ld.so.conf
3) run 'ldconfig'

Then try to install again.  To set DBI_DSN, see 
http://search.cpan.org/src/DBDPG/DBD-Pg-1.49/README

I just read through the README though, and it looks like you might be able 
to skip steps 1-3 if you set POSTGRES_LIB to the location of libpq.so.4,
but I haven't tried that approach so I can't say if it will address this 
specific issue.