setup php with remote pgsql db?

XYZ

hi,

I want to install php w/ --enable-pgsql, but it requires a path to the installation of pgsql. My pgsql is on a separate machine, so i cannot point it there (or could i?). I googled and someone mentioned something about needing libpg on the client machine ( http://aspn.activestate.com/ASPN/Mail/Message/php-db/1326508 ), but i am not sure as to where to get it. Please advise or point me in the right direction. any help would be much appreciated. Thanks in advance.

-XYZ

zhabala

I think it is not connected with instalation. Usually the PHP is compiled with pgsql support. It only has to be enabled in php.ini there is such line with

extension=php_pgsql.dll ; for windows

extension=pgsql.so ; for linux

So you have to uncomment it and restart apache. Then you can use pg_connect command in your php script to connect to whichever server in the internet where your db resides in.

Zdenek

piersk

Bear in mind that if the db server is a few hops away then it will take longer for the page to be displayed cos of the time taken to send data backwards and forwards...

XYZ

Hi, thanks for the replies . . . I already got it working . . .
I couldnt configure w/ enable-pgsql option on because the options requires a path to pgsql installation. what i end up doing is copy the lib and one other folder over from the db machaine, and pointed configure to it, and it worked.