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"

stackoverflow.com/a/7240866/705198 Covers this issue on debian linux derivatives. — AndrewPK
– AndrewPK, Commented May 17, 2012 at 20:23

Jorge Olivares · Accepted Answer · 2014-01-21 12:59:49Z

93

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, 2014 at 12:59

answered May 17, 2012 at 17:51

Jorge Olivares

1,5021 gold badge11 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Aaron Over a year ago

Hi do you know how I would install it in windows? Sorry I don't have ubuntu yet..

Jorge Olivares Over a year ago

Depends. You are using wamp or something like that?

Jorge Olivares Over a year ago

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.

wmfrancia Over a year ago

Just an update on this old thread for php7 the command is: sudo apt install php7.0-pgsql

Floggedhorse Over a year ago

Running php 7.0 - I had to add "extension=pgsql.so" to "php.ini" = "open database successfully" = :)

|

John Fisher · Accepted Answer · 2012-05-17 18:06:47Z

65

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, 2012 at 18:06

John Fisher

22.8k2 gold badges43 silver badges67 bronze badges

answered May 17, 2012 at 18:00

Sachin Puri

8867 silver badges6 bronze badges

2 Comments

IIllIIll Over a year ago

I'm still seeing PHP Fatal error: Call to undefined function pg_connect(), although I know I've uncommented it. Ideas?

Ericksan Pimentel Over a year ago

Related to Postgres I had the line extension=pdo_pgsql, after uncommenting the error was solved

Nathan G · Accepted Answer · 2018-12-08 10:21:35Z

22

For debian/ubuntu install

sudo apt-get install php-pgsql

answered Dec 8, 2018 at 10:21

Nathan G

1,8791 gold badge20 silver badges18 bronze badges

1 Comment

TheMet4lGod Mar 18 at 14:39

This is tagged Windows. Linux suggestions are unhelpful.

Braian Coronel · Accepted Answer · 2019-02-03 00:55:05Z

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

Wojciech Legierski · Accepted Answer · 2015-09-28 10:37:55Z

6

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

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

answered Sep 28, 2015 at 10:37

Wojciech Legierski

611 silver badge3 bronze badges

2 Comments

Daniel L. VanDenBosch Over a year ago

Where would one find httpd.conf

Rishu Ranjan Over a year ago

inside config file for your apache server. If you are using mamp, then C:\MAMP\bin\apache\conf\httpd.conf

augustowebd · Accepted Answer · 2014-08-18 19:39:36Z

3

just install the database driver:

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

and be happy!

answered Aug 18, 2014 at 19:39

augustowebd

3922 silver badges8 bronze badges

1 Comment

Maks3w Over a year ago

And reload the PHP config (reload apache/nginx etc) after install new extensions

Matthew Lock · Accepted Answer · 2021-09-25 02:31:59Z

3

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

edited Sep 25, 2021 at 2:31

Matthew Lock

13.6k14 gold badges97 silver badges132 bronze badges

answered Oct 1, 2014 at 13:15

Panagiotis Piperopoulos

5645 silver badges11 bronze badges

1 Comment

Matthew Lock Over a year ago

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

Youzef · Accepted Answer · 2022-04-28 22:58:53Z

2

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, 2022 at 22:58

Youzef

8582 gold badges13 silver badges28 bronze badges

Comments

rinat.io · Accepted Answer · 2012-05-17 17:51:53Z

1

You need to isntall pdo_pgsql package

answered May 17, 2012 at 17:51

rinat.io

3,1982 gold badges24 silver badges26 bronze badges

2 Comments

Aaron Over a year ago

How do I install that package on windows?

rinat.io Over a year ago

Maybe pecl install pdo_pgsql. Not sure

user5699115 · Accepted Answer · 2015-12-19 20:43:48Z

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, 2015 at 20:43

user5699115

111 bronze badge

1 Comment

Daniel L. VanDenBosch Over a year ago

Awesome thanks, if I were using xammp would I put this in the C:\xampp folder?

General Grievance · Accepted Answer · 2020-10-14 12:25:44Z

1

$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.

edited Oct 14, 2020 at 12:25

General Grievance

5,12039 gold badges40 silver badges60 bronze badges

answered Oct 14, 2020 at 8:21

kavya

312 bronze badges

Comments

rtfmpliz · Accepted Answer · 2020-03-26 11:39:28Z

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, 2020 at 11:39

rtfmpliz

3592 silver badges8 bronze badges

Comments

Lord Fers · Accepted Answer · 2022-06-23 01:30:40Z

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, 2022 at 1:30

answered Jun 22, 2022 at 5:55

Lord Fers

11 bronze badge

Comments

s1nfor · Accepted Answer · 2024-12-15 20:31:24Z

0

Configure correctly extension directory in php.ini:

; Directory in which the loadable extensions (modules) reside.
; https://php.net/extension-dir
;extension_dir = "./"
; On windows:
;extension_dir = "ext"

If you on Windows just remove ";" on last line

answered Dec 15, 2024 at 20:31

s1nfor

112 bronze badges

Collectives™ on Stack Overflow

How do I enable php to work with postgresql?

14 Answers 14

6 Comments

2 Comments

1 Comment

Enable PHP to work with PostgreSQL in Apache

Comments

2 Comments

1 Comment

1 Comment

Comments

2 Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

14 Answers 14

6 Comments

2 Comments

1 Comment

Enable PHP to work with PostgreSQL in Apache

Comments

2 Comments

1 Comment

1 Comment

Comments

2 Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related