You need to install the PostgreSQL client libraries on the box running DBD::Pg. The client libraries need to be installed before installing DBD::Pg.
See the bottom of this page for client installation directions. http://www.postgresql.org/docs/7.4/static/install-procedure.html -Alec On Thu, 3 Mar 2005 21:08:27 -0800 (PST), Gokul P. Nair wrote: > i would like to connect to a remote postgresql 8.1 server using a > perl script. The machine i'm trying to connect from is running > Debian and perl v5.6.1. In order to connect to the remote > postgresql server i assume i need DBI as well as DBD::Pg. well the > DBI installation went well but when i try to install DBD::Pg this > is what it gives me: > > debian:/usr/local/src/DBD-Pg-1.40# perl Makefile.PL Configuring Pg > Remember to actually read the README file! Path to pg_config? OS: > linux PostgreSQL version: .. > > **************** > WARNING! DBD::Pg no longer supports versions less than 7.2. > It is highly recommended that you upgrade PostgreSQL to a newer > version. **************** > > Using DBI 1.47 (for perl 5.006001 on i386-linux) installed in > /usr/local/lib/perl/5.6.1/auto/DBI/ Checking if your kit is > complete... Looks good > Note (probably harmless): No library found for -lpq Using DBI 1.47 > (for perl 5.006001 on i386-linux) installed in > /usr/local/lib/perl/5.6.1/auto/DBI/ Writing Makefile for DBD::Pg > > Do i even need DBD::Pg installed on the machine which is trying to > access the postgresql server through a perl script? if so why is > the very first step i.e. "perl Makefile.pl" failing? if no, how do > i connect to the server and run queries using perl? > > thanks in advance for all ur help. > > Gokul > > > __________________________________________________ Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com