connecting postgres with laravel

Question

Hello i'm trying to connect laravel 5.4 with postgres, after updating the database configuration file and running php artisan migrate, the following error appears:

[Illuminate\Database\QueryException]
 could not find driver (SQL: select * from information_schema.tables where t
 able_schema = public and table_name = migrations)
[PDOException]
 could not find driver

this is my .env file

DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5432
DB_DATABASE=Portail
DB_USERNAME=php
DB_PASSWORD=php

and this is my database.php file

'default' => env('DB_CONNECTION', 'pgsql'),
 'pgsql' => [
            'driver' => 'pgsql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '5432'),
            'database' => env('DB_DATABASE', 'Portail'),
            'username' => env('DB_USERNAME', 'php'),
            'password' => env('DB_PASSWORD', 'php'),
            'charset' => 'utf8',
            'prefix' => '',
            'schema' => 'public',
            'sslmode' => 'prefer', ],

and i use phpPgAdmin normally

http://stackoverflow.com/questions/25329302/laravel-error-pdoexception-could-not-find-driver-in-postgresql May helps you — BKF, Apr 26 '17 at 15:19
`extension=php_pdo_pgsql.dll` `extension=php_pdo_sqlite.dll` `extension=php_pgsql.dll` `;extension=php_phpdbg_webhelper.dll` `;extension_dir = "ext"` `extension_dir ="c:/wamp64/bin/php/php7.0.10/ext/"` — Fares Izem, Apr 27 '17 at 07:19

score 13 · Answer 1 · answered Apr 26 '17 at 15:35

13

sudo apt-get install php-pgsql. This is the command to install php pgsql driver in linux

answered Apr 26 '17 at 15:35

John Simon

818
11
25

i use windows and my php_pgsql work i connect php with phppgadmin without laravel but with laravel don't work – Fares Izem Apr 27 '17 at 06:57
That fixed my problem. I was trying `php artisan migrate` and got the error: `“could not find driver (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')”` Installing the driver to Ubuntu 20 fixed the problem. Thanks @JohnSimon – Nuri Engin Nov 27 '21 at 10:49

score 4 · Answer 2 · answered Apr 07 '21 at 06:23

I had a similar problem using on Ubuntu18.04 using php7.4 Solution:

First check you PHP version with php -v, in my case the version come out to be php7.4 so installed the necessary driver with apt-get install php7.4-pgsql
Finally restart the PHP server

score 1 · Answer 3 · answered Apr 27 '17 at 07:45

1

I found the solution there are two php.ini files

C:\wamp64\bin\apache\apache2.4.9\bin
C:\wamp64\bin\php\php7.0.10

i must do uncommented php_pdo_pgsql.dll and php_pgsql.dll in the two files thanks for your help all

answered Apr 27 '17 at 07:45

Fares Izem

177
2
2
9

connecting postgres with laravel

3 Answers3