[Resolved] PHP no Postgresql

[jlpierce]

Hello all,

I have a secure apache installation with php and mysql. All works well, but php was not built with postgresql, do I need to rebuild the entire installation including apache or can I just rebuild php and put it in the proper place. As far as I know php was built as a module to apache.

Thanks

[Anon]

Yes you can compile it and add it to the php.ini or use dl('pgsql.so') in your code

The docs will show you how to compile a php extension and use it.

or if you have the source from the previuos compile rerun the ./configure appending --with-pgsql

run make && make install
restart apache...

if you get errors check /etc/ls.so.conf
make sure the postgresql libs are in one of the path statements

[jlpierce]

Hello Chauncey,

You indicate that I can compile it and that the docs will show me how to compile a php extension and use it. I have searched the online help and php website and can find nothing on compiling an extension. Just how to rebuild the entire thing, including apache.

Could you point me in the right direction.

Thanks.

John

[Anon]

look in the README of this product
http://msalem.translator.cx/dist/phpperl/

It may help you...

[Anon]

It would be easier to re-compile php

[jlpierce]

That helped, thanks alot. I can now connect to postgresql through php.

John