Laravel 5 with Postgres SQL

Question

I’m working on Laravel 5 with postgres as database. I’ve configured postgres 9.4 and pgAdmin III and these are working normally. When I try to run migrate it is giving me error:

[PDOException]
could not find driver

This is my database.php

'default' => 'pgsql',

'pgsql' => [            'driver'   => 'pgsql',          
                        'host'     => '127.0.0.1',          
                        'database' => 'fms',            
                        'username' => 'postgres',           
                        'password' => 'root',           
                        'charset'  => 'utf8',           
                        'prefix'   => '',           
                        'schema'   => 'public',         ],

Initially I though, it was due to configuration of postgres on windows 7 but I tried with plain php it works perfect

<?php
   $host        = "host=127.0.0.1";
   $port        = "port=5432";
   $dbname      = "dbname=fms";

   $db = pg_connect( "$host $port $dbname user=postgres password=root"  );
   if(!$db){
      echo "Error : Unable to open database\n";
   } else {
      echo "Opened database successfully\n";
   }
?>

I’ve enabled php_pgsql and php_pdo_sql in wamp as well. I’m not sure how to fix this on laravel 5.

In your php.ini can you uncomment the extension=pdo_pgsql.so ? — Sulthan Allaudeen
– Sulthan Allaudeen, Commented May 27, 2015 at 12:02

wp78de · Accepted Answer · 2018-07-26 22:32:42Z

38

As you said you already choosed Default Database as Postgres SQL

'default' => 'pgsql',

It is a must that you need to uncomment the pdo and postgres shared object in your php configuration settings (php.ini)

i.e., You need to uncomment the following lines in your php.ini

extension=pdo_pgsql.so
extension=pgsql.so

Note :

Don't forget to stop and start your apache after doing this changes (or php-fpm if using that instead).

edited Jul 26, 2018 at 22:32

wp78de

19.1k7 gold badges49 silver badges78 bronze badges

answered May 27, 2015 at 12:19

Sulthan Allaudeen

11.6k12 gold badges51 silver badges66 bronze badges

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

1 Comment

Ryan Over a year ago

I ran sudo apt install php7.4-pgsql php.net/manual/en/pgsql.installation.php#119801 and then service php7.4-fpm restart but I still get "Unable to load dynamic library 'pdo_pgsql'"

anchor · Accepted Answer · 2015-12-08 00:56:34Z

I had the same problem with Laravel-WAMP-PostgreSql driver not found exception. I even successfully established direct connection to Postgre as you have, but with no luck with the "php artisan migrate" command.

After long research I found out that there are multiple php.ini files in which "extension=php_pdo_pgsql.dll" and "extension=php_pgsql.dll" are comented out.

The solution is (of course) to uncoment the extensions in the following files:

~/wamp/bin/php/php5.5.*/php.ini
~/wamp/bin/php/php5.5.*/phpForApache
~/wamp/bin/php/php5.5.*/php.ini.install
~/wamp/bin/php/php5.5.*/php.ini-development
~/wamp/bin/php/php5.5.*/php.ini-production and
~/wamp/bin/apache/apache2.4.9/php.ini

** You can leave off the "php.ini-development" and "php.ini-production" (don't need to uncoment these files).

nichoio · Accepted Answer · 2017-06-18 18:12:59Z

3

Like @jeff said, this is probably caused by not setting DB_CONNECTION=pgsql in the .env-file. The .env-file has MySQL preconfigured, so you must edit this file.

answered Jun 18, 2017 at 18:12

nichoio

7,9074 gold badges32 silver badges44 bronze badges

Comments

Ravistm · Accepted Answer · 2018-05-02 07:17:23Z

3

You have to make DB related changes in

config/database.php
.env file

and other settings in

php.ini settings

If you are still getting error, then clear cache and config

php artisan cache:clear
php artisan config:clear

It should work now!

answered May 2, 2018 at 7:17

Ravistm

2,26326 silver badges26 bronze badges

2 Comments

sebasdev Over a year ago

I stopped the command running 'php artisan:serve' and then I run your commands and again run 'php artisan:serve' and that worked!. Thanks very much.

Hawili Over a year ago

I had everything right, I was 100% sure cause I tried using external scripts, the part of clearing cache and config did it! thanks

Ash · Accepted Answer · 2019-07-31 11:31:30Z

1

Run this command to easily uncomment the lines extension=pdo_pgsql.so and extension=pgsql.so from php.ini

sed -ri -e 's!;extension=pdo_pgsql!extension=pdo_pgsql!' $PHP_INI_DIR/php.ini

sed -ri -e 's!;extension=pgsql!extension=pgsql!' $PHP_INI_DIR/php.ini

If you do not have the drivers already installed, or it gives error like unable to load dynamic library PGSQL run this:

apt-get update && apt-get install -y libpq-dev && docker-php-ext-install pdo pgsql pdo_pgsql

This will install the pgsql and pdo_pgsql drivers.

answered Jul 31, 2019 at 11:31

Ash

7328 silver badges21 bronze badges

Comments

Jeff · Accepted Answer · 2017-05-04 11:04:12Z

0

you gotta modify .env file , then go to config>database.php and change the default to pgsql, and also in all your models file you need to change $protected $connection= 'pgsql'.

answered May 4, 2017 at 11:04

Jeff

95 bronze badges

Comments

Ronald Garcia Magcalas · Accepted Answer · 2019-11-18 16:04:37Z

-1

I'm using PHP7.3 and this worked for me, I forgot this:

apt-get install php7.3-pgsql

Everything runs smoothly afterwards. Just use whatever version of PHP you are using.

answered Nov 18, 2019 at 16:04

Ronald Garcia Magcalas

112 bronze badges

Collectives™ on Stack Overflow

Laravel 5 with Postgres SQL

7 Answers 7

1 Comment

Comments

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

Comments

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related