Re: cannot install DBD::Pg

LLC wrote:
> Hi List;
>
> I'm trying to install DBD::Pg on a RedHat EL4 (64bit) box.
>
> I used CPAN to install DBI
>
> then I downloaded DBD::Pg and ran the make. When I run make test I get this. Any suggestions/help would be greatly appreciated...

It's been a while since I've played with 64 bit redhat but my
recollection is that you'll need to set LD_LIBRARY_PATH to /usr/lib64/
or something similar such that it points to a directory which contains
libpq.so.4, and then remake DBD::Pg.

HTH,

Fred

> Thanks in advance
>
> $ 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......skipped
> all skipped: Please install Module::Signature so that you can verify the integrity of this and other distributions.
> t/00basic...........ok 1/3# Failed test (t/00basic.t at line 11)
> t/00basic...........NOK 2# Tried to use 'DBD::Pg'.
> # Error: Can't load '/tmp/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/lib64/perl5/5.8.5/x86_64-linux-thread-multi/DynaLoader. pm line 230.
> # at (eval 4) line 2
> # Compilation failed in require at (eval 4) line 2.
> t/00basic...........ok 3/3# Looks like you failed 1 tests of 3.
> t/00basic...........dubious
> Test returned status 1 (wstat 256, 0x100)
> DIED. FAILED test 2
> Failed 1/3 tests, 66.67% okay
> t/01connect.........#
> # Program Version
> # Perl 5.8.5 (linux)
> # DBD::Pg 1.49
> # PostgreSQL (compiled) ?
> # PostgreSQL (target) ?
> # PostgreSQL (reported) ?
> # Default port ?
> # DBI 1.51
> # DBI_DSN dbi:Pg:dbname="postgres"
> FAILED--Further testing stopped: Could not connect: install_driver(Pg) failed: Can't load '/tmp/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/lib64/perl5/5.8.5/x86_64-linux-thread-multi/DynaLoader. pm line 230.
> # No tests run!
> make: *** [test_dynamic] Error 9
>
>
>