Starting with PHP 7, on Ubuntu (i.e., 16+), you can run:
`sudo apt-get install php-pgsql`
为启用 PostgreSQL 支持，编译 PHP 时需要 --with-pgsql[=DIR]。DIR
是 PostgreSQL 的基本安装目录，默认是 /usr/local/pgsql。如果共享对象模块可用，可以使用 php.ini
中的 extension 指令或者 dl() 函数加载 PostgreSQL 模块。
Starting with PHP 7, on Ubuntu (i.e., 16+), you can run:
`sudo apt-get install php-pgsql`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,
SerjikAn easy way to install in ubuntu(debain)
Just run " apt-get install php5-pgsql "if you get
/pgsql.c:789: error: 'from' undeclared (first use in this function)
etc. compiling in linux its a typo in the define of pgsql.c file
change to this
#if !HAVE_PQESCAPE_CONN
#define PQescapeStringConn(conn, to, from, len, error) PQescapeString(to, from, len)
#endifOn 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!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