Problems compiling for pgsql support

I have been trying to get php version 4.3.3 to work with postgresql for days
now. I have postgresql installed and running on the server. We are using
the WHM/Cpanel management suite so we are using apache 1.3.29 aswell.

I have php currently configured as reported by phpinfo()

'./configure' '--with-apxs=/usr/local/apache/bin/apxs' '--with-xml'
'--enable-bcmath' '--enable-calendar' '--enable-ftp' '--with-gd'
'--with-jpeg-dir=/usr/local' '--with-png-dir=/usr'
'--with-xpm-dir=/usr/X11R6' '--with-gettext' '--enable-magic-quotes'
'--with-mysql' '--with-pear' '--enable-sockets' '--enable-track-vars'
'--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf'
'--enable-versioning' '--with-zlib'

When I try to reconfigure php with the '--with-pgsql-dir=/usr' flag php
appears to compile and configure properly yet the builddate in phpinfo();
never changes.

In looking thru the php.net website it seems like there have been a lot of
issues with getting pgsql and php working properly. I have exhaused my
ideas on what could be the cause and hope maybe someone out there might have
a few tricks I can try.

Thanks in advance.

Aaron


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Re: Problems compiling for pgsql support

Aaron.....

> I have php currently configured as reported by phpinfo()
>
> './configure' '--with-apxs=/usr/local/apache/bin/apxs' '--with-xml'
> '--enable-bcmath' '--enable-calendar' '--enable-ftp' '--with-gd'
> '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr'
> '--with-xpm-dir=/usr/X11R6' '--with-gettext' '--enable-magic-quotes'
> '--with-mysql' '--with-pear' '--enable-sockets' '--enable-track-vars'
> '--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf'
> '--enable-versioning' '--with-zlib'

So to me it looks like the php that is running does not include the
postgresql php module which contains the functions to talk to the
database. But maybe you are using pear as the interface between apache,
php and postgresql. I guess you can't connect to the database, right?

> When I try to reconfigure php with the '--with-pgsql-dir=/usr' flag php
> appears to compile and configure properly yet the builddate in
> phpinfo(); never changes.

Maybe you have to restart Apache? Php is most usually an Apache module
and unless Apache restarts the changes won't be there.

What OS are you using? I use Debian and don't often compile I just grab
the packages.....

brew


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: Problems compiling for pgsql support

I finally upgraded php to version 4.3.4 and got pgsql to take when
rebuilding. The php rebuild was not producing any noticeable errors.

PHP was being rebuilt thru the cpanel "update Apache" module. As the final
stage of this step Apache is restarted. So i never really understood why
the build date on 4.3.3 was not getting updated.

Anyway thanks to everyone whom responded.


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org