Wayne wrote:
> Hi All,
> I'm having some problems installing DBD::PG. In
> paticulate with libpq-fe.h. I set my enviroment
> variables POSTGRES_LIB and POSTGRES_INCLUDE
> to point at the right path and still no luck.Here is the sequences
> of events:
>
> [root@localhost DBD-Pg-1.01]# perl Makefile.PL
> Configuring Pg
> Remember to actually read the README file !
> OS: linux
> Using DBI 1.18 installed in
> /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI
> Checking if your kit is complete...
> Looks good
> Note (probably harmless): No library found for -lpq <------ Why is this
> not getting pivk-up?
> Writing Makefile for DBD::Pg
>
> [root@localhost DBD-Pg-1.01]# make
> mkdir blib
> mkdir blib/lib
> mkdir blib/lib/DBD
> mkdir blib/arch
> mkdir blib/arch/auto
> mkdir blib/arch/auto/DBD
> mkdir blib/arch/auto/DBD/Pg
> mkdir blib/lib/auto
> mkdir blib/lib/auto/DBD
> mkdir blib/lib/auto/DBD/Pg
> mkdir blib/man3
> cp Pg.pm blib/lib/DBD/Pg.pm
> cp dbd-pg.pod blib/lib/DBD/dbd-pg.pod
> /usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0
> /usr/lib/perl5/5.6.0/ExtUtils/xsubpp -typemap
> /usr/lib/perl5/5.6.0/ExtUtils/typemap Pg.xs > Pg.xsc && mv Pg.xsc Pg.c
> gcc -c -I/usr/local/pgsql:/usr/local/pgsql/include:/usr/local/pgsql/lib
> -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI
> -fno-strict-aliasing -O2 -march=i386 -mcpu=i686 -DVERSION=\"1.01\"
> -DXS_VERSION=\"1.01\" -fPIC -I/usr/lib/perl5/5.6.0/i386-linux/CORE Pg.c
>
> In file included from Pg.xs:13:
> Pg.h:17:22: libpq-fe.h: No such file or directory
> make: *** [Pg.o] Error 1
>
> [root@localhost DBD-Pg-1.01]# find / -name libpq-fe.h -print
> /usr/local/pgsql/include/libpq-fe.h
> /usr/local/postgresql-7.1/src/interfaces/libpq/libpq-fe.h
> [root@localhost DBD-Pg-1.01]#
>
> In desperation I put both path in the environment variables
> POSTGRES_LIB and POSTGRES_INCLUDE.
> Can someone correct me?
> Thanks.
> Wayne
>
>
On a RedHat system, if you've used the rpm's for Pg, then
POSTGRES_LIB = /usr/lib/pgsql
POSTGRES_INCLUDE = /use/include/pgsql
If you are on an rpm based system, you may have to make sure that you've
uninstalled (by way of rpm -e whatever.rpm). If you are still having
problems you might try putting a line in /etc/ld.so.conf & then
ldconfig. On an rpm based system, you are probalbly best advised to use
the rpm distro of PostgreSQL, easily obtainable from their website.
good luck
