요구 조건
An easy way to install in ubuntu(debain)
Just run " apt-get install php5-pgsql "
설치
PostgreSQL 지원을 활성화하려면, PHP를 컴파일 할 때 --with-pgsql[=DIR] 이 필요합니다. DIR은 PostgreSQL 베이스 설치 디렉토리로, 기본값은 /usr/local/pgsql입니다. 공유 오브젝트 모듈을 이용할 수 있으면, php.ini에서 extension 지시어나 dl()을 사용하여 PostgreSQL 모듈을 읽어들일 수 있습니다.
add a note
User Contributed Notes
설치 - [5 notes]
Anto Binish Kaspar ¶
3 years ago
samuel+php dot net at dionne-riel dot com ¶
2 years ago
On PHP 5.3, you may encounter this error.
Cannot create new link. Too many open links
I did with Archlinux. pgsql.so was active.
To resolve the issue, I had to active pdo.so and pdo_pgsql.so. Hope this helps!
Serjik ¶
3 years ago
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
Riyas ¶
3 years ago
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 ¶
4 years ago
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