I'm having an awful time getting pgsql support in PHP. I always compile Apache, PHP, mod_ssl and friends with Apachetoolbox; been doing it that way for years. I don't however let ATB try to compile pgsql (which fails anyway and is also out of date). I'm at a point right this very minute where I need a PHP installation that has pgsql support. I can't find any way of enabling it after the fact with PHP so I'm assuming it's a compile-time-only option. ATB gives me the option of PHP's configuration script (which includes the ./configure line). I added --with-pgsql=/usr/local/pgsql to PHP's ./configure line. I then configured Apache like normal, compiled, and installed. I'm still left with no pgsql support. Is there something I'm missing? I'm sure it's probably something obivous. If someone could give me a kick in the right direction I'd appreciate it. For the record this is a RH9 box and no, RH's RPMs are not an option. ATB is compiling PHP 4.3.4. I'm trying to get Roaring Penguin's Can-It Pro up and running. It requires PostgreSQL and PostgreSQL support in PHP.
I've tried --with-pgsql, --with-pgsql=shared, and --with-pgsql=shared,/usr/local/pgsql. For the record /usr/local/pgsql/lib is in my ld.so.conf and ldconfig confirms that. My version of pgsql is 7.4.2. It's compile and install was flawless. Thanks Justin