Con el fin de habilitar el soporte de PostgreSQL, --with-pgsql[=DIR] es requerido cuando se compila PHP. DIR es el directorio base donde está instalado PostgreSQL, por defecto generalmente es /usr/local/pgsql en sistemas linux. Si el módulo de objetos compartidos está disponible, el módulo PostgreSQL puede ser cargado usando la directiva extension en php.ini o la función dl().

add a note

User Contributed Notes 7 notes

sean at cockroachlabs dot com
7 years ago
Starting with PHP 7, on Ubuntu (i.e., 16+), you can run:

`sudo apt-get install php-pgsql`
14 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.

7 years ago
for php 7, "sudo apt install php7.0-pgsql" worked for me
Anto Binish Kaspar
14 years ago
An easy way to install in ubuntu(debain)
Just run " apt-get install php5-pgsql "
zonetejasmikel at yahoo dot com
9 years ago
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
#define PQescapeStringConn(conn, to, from, len, error) PQescapeString(to, from, len)
samuel+php dot net at dionne-riel dot com
13 years ago
On PHP 5.3, you may encounter this error.
Cannot create new link. Too many open links

I did with Archlinux. was active.

To resolve the issue, I had to active and Hope this helps!
14 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
To Top