Re: [PHP-INST] problem compiling php for pgsql

On Sat, 29 Jul 2000, dave wrote:

> Hi,
>
> Not sure which list this should go to, so I've posted to both.
>
> I installed pgsql 7.02, from the RH RPMS, and got pgsql working OK. I
> then went back to my php-4.0.1pl2 distribution which I'd had working
> for a while to try and compile in pgsql.
>
> tried --with-pgsql (also =/usr, =/usr/local, =/usr/local/pgsql)
>
> On compiling php, each time I get
>
> /bin/sh /usr/local/php-4.0.1pl2/libtool --silent --mode=compile gcc
> -DHAVE_CONFIG_H -I. -I/usr/local/php-4.0.1pl2/ext/pgsql
> -I/usr/local/php-4.0.1pl2 -I/usr/local/php-4.0.1pl2/main
> -I/usr/local/apache/include -I/usr/local/php-4.0.1pl2/Zend
> -I/usr/local/php-4.0.1pl2 -I/usr/local/php-4.0.1pl2/ext/mysql/libmysql
> -I/usr/local/php-4.0.1pl2/ext/xml/expat/xmltok
> -I/usr/local/php-4.0.1pl2/ext/xml/expat/xmlparse -I
> -DXML_BYTE_ORDER=12 -g -O2 -c pgsql.c
> In file included from pgsql.c:29:
> php_pgsql.h:32: postgres.h: No such file or directory
> php_pgsql.h:33: libpq-fe.h: No such file or directory
> php_pgsql.h:39: libpq/libpq-fs.h: No such file or directory
>
> So I went back to pgsql to look for these include files. I couldn't
> find an RPM for them, so I installed postgresql-7.0.2-base source. I
> did a make install-headers (am I on the wrong track yet). This
> appeared to install the headers to /usr/local/pgsql/include, although
> I noticed there was no
>
> libpq-fe.h
>
> My recompile of pgsql gave the same results (even for postgres.h). I
> can't believe I'm going about this the right way.
>
> Does anyone know what I should be doing? I'd like to try and keep this
> as much RPM based as possible (i.e. I did think of downloading ALL
> sources and compiling the lot, but I'd like to avoid that - I mean my
> pgsql install works fine)

Either do a *full* install of PostgreSQL, not only headers, from sources
and remove all the RPM's, or, because you seem to prefer them, install
also postgresql-devel-7.0.2-2.i386.rpm, which I think is missing from your
system, remove /usr/local/pgsql, ./configure --with-pgsql=/usr and
recompile. Having bits of postgres installed from RPM's, other bits from
sources to another place is very likely to play havoc on PHP's configure
script.

-- Jouni Ahto