>if the install directory /usr/local/pgql or /usr/local/pgsql > >What does your phpinfo() give for postgres? > > >> By the way, I have set the LD_LIBRARY_PATH and I have included >> /usr/local/pgsql/lib >> path in /etc/ld.so.conf.
You should also do "ld_config" I think... I do that any time I muck with /etc/ld.so.conf >> >> Compiled PHP4 as follows: >> ./configure --enable-track-vars --with-gettext --enable-force-cgi-redirect >> --with-apache=../apache_1.3.26 --without-mysql >> --with-pgsql=/usr/local/pgql >> >> PHP code is working with Apache because other things work. Just that >> pg_connect() is always 'unknown function'. Aha! That means that even though you *ASKED* configure to give you --with-pgsql=/usr/local/pgql it didn't work. ./configure was able to stumble through, but it did give you a warning message about it, somewhere in that mass that scrolled by. You could look in config.log, only it doesn't contain the "Yes/No" and other error output, so it only shows that ./configure *tried* to get PostgreSQL, not what actually happened. (Grrrrr.) You could try reading config.cache, if your brain is twisted enough. Mine isn't. :-( Re-do the ./configure, only this time like this: ./configure ... 2>&1 > configure.output & Or is that '2&>1' ? I never really did grok the combination of > with & and how it turns into "shove stderr output in with stdout"... Then, you can use: tail -f configure.output to examine configure.output as it is happening, but also use vi or less or grep to look at it again later. Don't ask me why ./configure itself doesn't give you the info you need in config.log -- I sure don't understand it. Anyway, for some reason, PostgreSQL never got compiled into PHP, which is why there is no function named "pg_connect" First Guess: /usr/local/pgql should be /usr/local/pgsql or /usr/local/psql or something other than /usr/local/pgql Also don't ask me to explain why configure would just continue on and not give a fatal error when it can't give you what you asked for... As near as I can figure, if what you asked for is what it would have done by default, but it still can't do it, it will just keep going... That's pretty silly, if you ask me. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
