PGSQL driver not found in Laravel PHP Framework

Question

Hi I am using Laravel PHP framework on CentOS 6.3. I have PostgreSQL 9.1 installed, along with PDO and PDO-PGSQL. Under application/config/database.php I have set Laravel to use PostgreSQL:

'default' => 'pgsql',


'connections' => array(

    'pgsql' => array(
        'driver'   => 'pgsql',
        'host'     => 'localhost',
        'database' => 'dbname',
        'username' => 'username',
        'password' => 'shhhpass',
        'charset'  => 'utf8',
        'prefix'   => '',
        'schema'   => 'public',
    ),
),

However, visiting any page gives me the error:

Message:

could not find driver
Location:     

/home/dev/public_html/laravel/database/connectors/postgres.php on line 37

Any ideas? Thanks!

Nikola K. · Accepted Answer · 2012-09-24 19:20:03Z

7

Run sudo apt-get install php5-pgsql on your terminal.

In other words, install the PostgreSQL driver for PHP.

edited Sep 24, 2012 at 19:20

Nikola K.

7,15313 gold badges33 silver badges39 bronze badges

answered Sep 24, 2012 at 18:09

Koen Schmeets

1051 bronze badge

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

1 Comment

Omid Kamangar Over a year ago

The OP stated that he is using CentOS. These instructions are for Debian/Ubuntu.

Omid Kamangar · Accepted Answer · 2012-09-18 16:32:30Z

6

The line giving that error is this:

$connection = new PDO($dsn, $username, $password, $this->options($config));

It is trying to load the PDO driver for pg.

Did you check that the pdo extension is enabled in PHP configuration files? Check the /etc/php.d/pgsql.ini and /etc/php.d/pdo.ini.

Hope this helps.

answered Sep 18, 2012 at 16:32

Omid Kamangar

5,7889 gold badges44 silver badges70 bronze badges

1 Comment

Mugoma J. Okomba Over a year ago

Note: After installing the PDO driver one needs to restart Apache for the changes to be effected: sudo systemctl restart httpd.service

Collectives™ on Stack Overflow

PGSQL driver not found in Laravel PHP Framework

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related