On a Windows server, configured with Apache, adding the following line to httpd.conf to load libpq.dll can save you a lot of time :
LoadFile "C:/Program Files/PostgreSQL/8.4/bin/libpq.dll"
Note that you will have to change your folder accordingly to the installation path and version of PostgreSQL you have installed. Also note that having Apache and PostgreSQL on the same server for production environments is not recommended.
Cheers,
Serjik
インストール手順
PostgreSQLサポートを利用可能とするには、PHPコンパイル時に --with-pgsql[=DIR] を指定することが必要です。DIR は PostgreSQL のインストールディレクトリで、デフォルトは /usr/local/pgsql です。 共有オブジェクトモジュールが利用可能な場合、php.ini の extension ディレクティブ または dl() 関数によりPostgreSQLモジュール をロードすることが可能です。
インストール手順
Serjik
28-Aug-2009 02:54
28-Aug-2009 02:54
Anto Binish Kaspar
08-Jul-2009 11:39
08-Jul-2009 11:39
An easy way to install in ubuntu(debain)
Just run " apt-get install php5-pgsql "
Riyas
03-Jun-2009 01:48
03-Jun-2009 01:48
If you chose NOT TO replace the newer (>5.2.6) php_pgsql.dll with the old one (from 5.2.5) as mentioned in the note above, then libpq.dll must be available in your PATH.
Also note that the libpq.dll that comes with your installation of PostgreSQL will not work. You have to use the one available here:
http://downloads.php.net/pierre/libpq-php-4.4.9-5.2.6.zip.
Place the extracted dll in your php root directory (where php.exe resides)
Simon
02-Mar-2009 04:59
02-Mar-2009 04:59
Windows users should be mindful that since 5.2.6 it seems that the version of php_pgsql.dll supplied is dynamically linked and requires libpq.dll.
The version supplied in 5.2.5 is statically linked and does not have this dependency, if you cannot load the Postgres extension grab php_pgsql.dll from the 5.2.5 distribution
