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

    9 days later

    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

    or

    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

      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...

        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.

          Write a Reply...