problem installing DBD::Pg

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.
#  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.........Use of uninitialized value in concatenation (.) or string at t/01connect.t line 74.
Use of uninitialized value in concatenation (.) or string at t/01connect.t line 74.
Use of uninitialized value in concatenation (.) or string at t/01connect.t line 74.
Use of uninitialized value in concatenation (.) or string at t/01connect.t line 74.
Use of uninitialized value in concatenation (.) or string at t/01connect.t line 74.
Use of uninitialized value in concatenation (.) or string at t/01connect.t line 74.
#
# Program               Version
# Perl                  5.8.5 (linux)
# DBD::Pg
# PostgreSQL (compiled)
# PostgreSQL (target)
# PostgreSQL (reported)
# Default port
# DBI                   1.52
# DBI_DSN
skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file.
t/01constants.......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.
 at t/01constants.t line 4
Compilation failed in require at t/01constants.t line 4.
BEGIN failed--compilation aborted at t/01constants.t line 4.
# Looks like your test died before it could output anything.
t/01constants.......dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-28
        Failed 28/28 tests, 0.00% okay
t/01setup...........skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file.
t/02attribs.........skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file
t/03dbmethod........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.
 at t/03dbmethod.t line 16
Compilation failed in require at t/03dbmethod.t line 16.
BEGIN failed--compilation aborted at t/03dbmethod.t line 16.
# Looks like your test died before it could output anything.
t/03dbmethod........dubious
        Test returned status 255 (wstat 65280, 0xff00)
t/03smethod.........skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file
t/04misc............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.
 at t/04misc.t line 8
Compilation failed in require at t/04misc.t line 8.
BEGIN failed--compilation aborted at t/04misc.t line 8.
# Looks like your test died before it could output anything.
t/04misc............dubious
        Test returned status 255 (wstat 65280, 0xff00)
t/05arrays..........skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file
t/06bytea...........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.
 at t/06bytea.t line 7
Compilation failed in require at t/06bytea.t line 7.
BEGIN failed--compilation aborted at t/06bytea.t line 7.
# Looks like your test died before it could output anything.
t/06bytea...........dubious
        Test returned status 255 (wstat 65280, 0xff00)
t/07copy............skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file
t/12placeholders....skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file
t/20savepoints......skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file
t/99_pod............ok
t/99cleanup.........skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file
Failed Test     Stat Wstat Total Fail  Failed  List of Failed
-------------------------------------------------------------------------------
t/00basic.t        1   256     3    1  33.33%  2
t/01constants.t  255 65280    28   56 200.00%  1-28
t/03dbmethod.t   255 65280    ??   ??       %  ??
t/04misc.t       255 65280    ??   ??       %  ??
t/06bytea.t      255 65280    ??   ??       %  ??
9 tests skipped.
Failed 5/16 test scripts, 68.75% okay. 29/34 subtests failed, 14.71% okay.
make: *** [test_dynamic] Error 255
  /usr/bin/make test -- NOT OK
Running make install
  make test had returned bad status, won't install without force
Failed during this command:
  DBDPG/DBD-Pg-1.49.tar.gz                     : make_test NO
=====================================================

How to define  DBI_DSN?


my OS - CentOS 4.3

Any suggestion will help


--=-----\/-----=--
 Vince