How do I enable php to work with postgresql?

Question

<?php

try {
   $dbh = new PDO('pgsql:host=localhost;port=5432;dbname=###;user=###;password=##');
   echo "PDO connection object created";
}
catch(PDOException $e)
{
      echo $e->getMessage();
}

?>

I get the error message "Could Not Load Driver"

http://stackoverflow.com/a/7240866/705198 Covers this issue on debian linux derivatives. — AndrewPK, May 17 '12 at 20:23
Possible duplicate of [Install pdo for postgres Ubuntu](https://stackoverflow.com/questions/7180869/install-pdo-for-postgres-ubuntu) — miken32, Dec 07 '18 at 01:13

Jorge Olivares · Answer 1 · 2014-01-21T12:59:49.440

91

You need to install the pgsql module for php. In debian/ubuntu is something like this:

sudo apt-get install php5-pgsql

Or if the package is installed, you need to enable de module in php.ini

extension=php_pgsql.dll (windows)
extension=php_pgsql.so (linux)

Greatings.

edited Jan 21 '14 at 12:59

answered May 17 '12 at 17:51

Jorge Olivares

1,477
1
11
14

Hi do you know how I would install it in windows? Sorry I don't have ubuntu yet.. – Aaron May 17 '12 at 17:53
Depends. You are using wamp or something like that? – Jorge Olivares May 17 '12 at 17:59
1

try to enable the module first, editing php.ini and searching for php_pgsql and remove the ; in the begining of the line. Then you need to reload your service. – Jorge Olivares May 17 '12 at 18:04
2

Just an update on this old thread for php7 the command is: sudo apt install php7.0-pgsql – wmfrancia Mar 07 '17 at 21:09
Running php 7.0 - I had to add "extension=pgsql.so" to "php.ini" = "open database successfully" = :) – Floggedhorse Mar 10 '19 at 13:09
Generally, the command is sudo apt-get install phpVersion-pgsql – ESCM Dec 04 '21 at 04:55

score 64 · Accepted Answer · edited May 17 '12 at 18:06

64

Try this:

Uncomment the following in php.ini by removing the ";"

;extension=php_pgsql.dll

Use the following code to connect to a postgresql database server:

pg_connect("host=localhost dbname=dbname user=username password=password")
    or die("Can't connect to database".pg_last_error());

edited May 17 '12 at 18:06

John Fisher

22,355
2
39
64

answered May 17 '12 at 18:00

Sachin Puri

876
7
6

I'm still seeing `PHP Fatal error: Call to undefined function pg_connect()`, although I *know* I've uncommented it. Ideas? – IIllIIll May 06 '15 at 20:17

score 14 · Answer 3 · answered Dec 08 '18 at 10:21

14

For debian/ubuntu install

sudo apt-get install php-pgsql

answered Dec 08 '18 at 10:21

Nathan B

1,625
1
17
15

Braian Coronel · Answer 4 · 2019-02-03T00:55:05.083

SO: Windows/Linux
HTTP Web Server: Apache
Programming language: PHP

Enable PHP to work with PostgreSQL in Apache

In Apache I edit the following configuration file: C:\xampp\php.ini

I make sure to have the following lines uncommented:

extension=php_pgsql.dll 
extension=php_pdo_pgsql.dll

Finally restart Apache before attempting a new connection to the database engine.

Also, I leave my code that ensures that the connection is unique:

private static $pdo = null;

public static function provideDataBaseInstance() {
    if (self::$pdo == null) {
        $dsn = "pgsql:host=" . HOST .
               ";port=5432;dbname=" . DATABASE .
               ";user=" . POSTGRESQL_USER .
               ";password=" . POSTGRESQL_PASSWORD;
        try {
            self::$pdo = new PDO($dsn);
        } catch (PDOException $exception) {
            $msg = $exception->getMessage();
            echo $msg . 
                 ". Do not forget to enable in the web server the database 
                  manager for php and in the database instance authorize the 
                  ip of the server instance if they not in the same 
                  instance.";
        }
    }
    return self::$pdo;
}

GL

score 5 · Answer 5 · answered Sep 28 '15 at 10:37

5

I have to add in httpd.conf this line (Windows):

LoadFile "C:/Program Files (x86)/PostgreSQL/8.3/bin/libpq.dll"

answered Sep 28 '15 at 10:37

Wojciech Legierski

51
1
3

1

Where would one find httpd.conf – Daniel L. VanDenBosch Mar 01 '18 at 14:31
inside config file for your apache server. If you are using mamp, then C:\MAMP\bin\apache\conf\httpd.conf – Rishu Ranjan Jun 16 '21 at 18:35

score 3 · Answer 6 · answered Aug 18 '14 at 19:39

3

just install the database driver:

apt-get install php5-pgsql php5-mysql php5-sqlite ... and so on ...

and be happy!

answered Aug 18 '14 at 19:39

augustowebd

382
2
8

1

And reload the PHP config (reload apache/nginx etc) after install new extensions – Maks3w Aug 18 '14 at 21:33

score 3 · Answer 7 · edited Sep 25 '21 at 02:31

I installed PHP on windows IIS using Windows Platform Installer (WPΙ). WPΙ creates a "PHP Manager" tool in "Internet Information Services (IIS) Manager" console. I am configuring PHP using this tool.

in http://php.net/manual/en/pdo.installation.php says:

PDO and all the major drivers ship with PHP as shared extensions, and simply need to be activated by editing the php.ini file: extension=php_pdo.dll

so i activated the extension using PHP Manager and now PDO works fine

PHP manager simple added the following two lines in my php.ini, you can add the lines by hand. Of course you must restart the web server.

[PHP_PDO_PGSQL]
extension=php_pdo_pgsql.dll

I do installed PHP via WPI, and it was enough for me to add extension=php_pgsql.dll to C:\Program Files\PHP\v7.1\php.ini at the end of the [ExtensionList] section — Matthew Lock, Sep 24 '17 at 10:08

score 1 · Answer 8 · answered May 17 '12 at 17:51

1

You need to isntall pdo_pgsql package

answered May 17 '12 at 17:51

rinat.io

3,168
2
21
25

3

How do I install that package on windows? – Aaron May 17 '12 at 17:53
2

Maybe `pecl install pdo_pgsql`. Not sure – rinat.io May 17 '12 at 17:56

score 1 · Answer 9 · answered Dec 19 '15 at 20:43

1

I and many other shave spent way too long on this - this needs a massive improvement. After spending hours, I finally copied php_pgsql.dll from php's ext directory to Apache24's root directory (wherever you installed it) and finally Apache was able to get the php/pg modules and dlls loaded.

answered Dec 19 '15 at 20:43

user5699115

11
1

Awesome thanks, if I were using xammp would I put this in the C:\xampp folder? – Daniel L. VanDenBosch Mar 01 '18 at 14:34

score 1 · Answer 10 · edited Oct 14 '20 at 12:25

$dbh = new PDO('pgsql:host=localhost;port=5432;dbname=###;user=###;password=##');

For PDO type connection uncomment

extension=php_pdo_pgsql.dll and comment with

;extension=php_pgsql.dll

$dbh = pg_connect("host=localhost dbname=### user=### password=####");

For pgconnect type connection comment

;extension=php_pdo_pgsql.dll and uncomment

extension=php_pgsql.dll

Both the connections should work.

score 0 · Answer 11 · answered Mar 26 '20 at 11:39

0

in my case there are 2 php.ini, I had to uncomment extension pdo_pgsql in both php.ini

in php folder
in apache folder

both inside in wamp folder

answered Mar 26 '20 at 11:39

rtfmpliz

159
1
6

score 0 · Answer 12 · answered Apr 28 '22 at 22:58

0

Because some answers seem outdated, if you are working with xampp, go to the php folder inside your xampp installation. In it open the php.ini file and uncomment

extension=pdo_pgsql
extension=pdo_sqlite

Remove the ; before these lines.

answered Apr 28 '22 at 22:58

Youzef

616
1
6
23

Lord Fers · Answer 13 · 2022-06-23T01:30:40.193

0

If you're using AppServ on Windows, then:

To Enable PHP to work with PostgreSQL in Apache

Go to C:\AppServ\php7\php.ini.
Uncomment this line: ;extension=pgsql removing the ;.

edited Jun 23 '22 at 01:30

answered Jun 22 '22 at 05:55

Lord Fers

1
1

How do I enable php to work with postgresql?

13 Answers13

Enable PHP to work with PostgreSQL in Apache

Linked

Related