Laravel Error PDOException Could not Find Driver in PostgreSQL

Question

I m trying to connect with PostgreSQL database through Laravel in order to do a php artisan migrate but doesn t seem to be directed since it s reading the database name of MySQL    Here are the commands from database php    connections    gt  array        sqlite    gt  array           driver      gt   sqlite            database    gt    DIR        database production sqlite            prefix      gt                   mysql    gt  array           driver       gt   mysql            host         gt   localhost            database     gt   database            username     gt   root            password     gt               charset      gt   utf8            collation    gt   utf8 unicode ci            prefix       gt                   pgsql    gt  array           driver      gt   pgsql            host        gt   localhost            database    gt   postgres            username    gt   postgres            password    gt   root            charset     gt   utf8            prefix      gt               schema      gt   public                sqlsrv    gt  array           driver      gt   sqlsrv            host        gt   localhost            database    gt   database            username    gt   root            password    gt               prefix      gt                   If I remove the MySQL paths I ll get    InvalidArgumentException  Database  mysql  not configured     EDIT  When trying to do php artisan migrate I get a  PDOException  could not find driver   I m using WAMP and I m in Win8 1  Using PostgreSQL as database    EDIT  Have experimented a series of alternative solutions but I m still ought to get this solved  The php ini file was checked in Apache  WAMP  from php folder  and PostgreSQL  The extension dir is correct as it being -  extension dir    c  wamp bin php php5 5 12 ext    The extension pdo pgsql dll and extension pgsql dll are uncommented   Done the PATH trick in the  System Variables  and rebooted  No chance    Thanks for the help so far   These are my drivers php pdo driver h  amp  php pdo h from C  Program Files  x86  PostgreSQL EnterpriseDB-ApachePHP php SDK include ext pdo  Information from phpinfo      PHP Version 5 5 12      Compiler  MSVC11  Visual C   2012  Configure Command  cscript  nologo   configure js  --enable-snapshot-build   --disable-isapi     --enable-debug-pack   --without-mssql   --without-pdo-mssql     --without-pi3web     --with-pdo-oci C  php-sdk oracle x64 instantclient10 sdk shared     --with-oci8 C  php-sdk oracle x64 instantclient10 sdk shared     --with-oci8-11g C  php-sdk oracle x64 instantclient11 sdk shared     --enable-object-out-dir    obj    --enable-com-dotnet shared     --with-mcrypt static   --disable-static-analyze   --with-pgo

User · Answer

I had the same error on PHP 7 3 7 docker with laravel   This works for me  apt-get update  amp  amp  apt-get install -y libpq-dev  amp  amp  docker-php-ext-install pdo pgsql pdo pgsql   This will install the pgsql and pdo pgsql drivers   Now run this command to 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

User · Answer

This worked for me     sudo apt-get -y install php5 6-pgsql   sudo service apache2 restart   I am working with 32bit Ubuntu 14

User · Answer

Just run this command sudo apt-get -y install php -mysql

User · Answer

In Linux Ubuntu  just install the driver like so  sudo apt-get install php-pgsql  This will install the driver with using your php current version

User · Answer

I realize this is an old question but I found it in a Google search so I m going to go ahead and answer just in case someone else runs across this  I m on a Mac and had the same issue  but solved it by using HomeBrew  Once you ve got it installed  you can just run this command   brew install php56-pdo-pgsql   And replace the 56 with whatever version of PHP you re using without the decimal point

User · Answer

I see you are using Windows  I was not able to fix this with enabling any of the extensions that come with my Windows WAMP Server  I tried PDO ODBC and others and even found the Microsoft Official PDO SQLSRV    The solution for me was to install the PDO SQLSRV drivers from a 3rd party website  I found the drivers through  http   robsphp blogspot nl 2012 06 unofficial-microsoft-sql-server-driver html   I usually don t use DLLs from random websites  but I was desperate and this worked for me  Hoping it might save others numerous hours of frustration

User · Answer

Old thread I know   but I lost a couple of hours of my life with this   You also need to set the DB info in the  env file   You don t have to specify the driver here because the default specified in database php is used  I think    I was struggling because it had DB CONNECTION mysql in the  env file and I was using pgsql

User · Answer

Using Laravel V 5 5 39 with Php 7 1 12 is working fine  but later  newer  php versions cause the problem  So  change Php version and you will get the solution 100

User · Answer

I had the same issue  This is what worked for me   There are 2 php ini files    C  wamp bin apache apache2 4 9 bin C  wamp bin php php5 5 12   NOTE  This is using my version of PHP and Apache  change to what yours are   The php ini file located in the both folders is what you need to update  the extentions    extension php pdo pgsql dll extension php pgsql dll   These are what you need to uncomment  remove the   symbol    Restart both Wamp and the Command Prompt   Hopefully it will work for you

User · Answer

In Windows 8 PC with Laragon 3 4 0 180809  I faced the same issue  It happened in my case because I updated Laragon and it added a new version of PHP  So in laragon bin php  I actually had two directories    php-7 1 20-Win32-VC14-x64 php-7 1 7-Win32-VC14-x64   I added 7 1 20 into my PATH variable  But in my Command Console  running php --ini was showing that the path actually was fetching from the older one  php-7 1 7-Win32-VC14-x64  So I deleted the old one  for safety  I put it in Recycle Bin   But Laragon failed to start after that   So  in laragaon etc apache2 mod php conf  I changed the path to the latest PHP version  Then restarted Laragon and the issue is resolved    Reference  How to add another PHP version - Laragon Forum

User · Answer

Solved after 3 hours     I am using WAMP  PHP 7 2 4   PostgreSQL 10  Laravel 5 6 29   Loaded PHP extensions  pgsql  pdo pgsql  from Wampserver 3 3  then I was able to connect to the PostgreSQL server with a simple php testcode from the www directory  But   php artisan migrate still returned      PDOException    could not find driver     I checked the shell  git bash for windows  with   php --ini  that returned C  wamp64 bin php php7 2 4 php ini instead of c  wamp64 bin apache apache2 4 33 bin php ini  loaded by WAMP So you have to uncomment pgsql and pdo pgsql extensions also in C  wamp64 bin php php7 2 4 php ini  and then migrate will work

User · Answer

For PHP 7 in Ubuntu you can also do   sudo apt-get install php7 0-pgsql   So  now you can do not uncomment lines in php ini  UPD  I have a same error  so problem was not in driver  I changed my database ini  but every time I saw an error  And I change database config in  env and errors gone

User · Answer

Be sure to configure the  default  key in app config database php  For postgres  this would be  default    gt   postgres    If you are receiving a  PDOException  could not find driver error  check to see if you have the correct PHP extensions installed   You need pdo pgsql so and pgsql so installed and enabled   Instructions on how to do this vary between operating systems     For Windows  the pgsql extensions should come pre-downloaded with the official PHP distribution   Just edit your php ini and uncomment the lines extension pdo pgsql so and extension pgsql so  Also  in php ini  make sure extension dir is set to the proper directory   It should be a folder called extensions or ext or similar inside your PHP install directory   Finally  copy libpq dll from C  wamp bin php php5    into C  wamp bin apache  bin and restart all services through the WampServer interface   If you still get the exception  you may need to add the postgres  bin directory to your PATH    System Properties -  Advanced tab -  Environment Variables In  System variables  group on lower half of window  scroll through and find the PATH entry  Select it and click Edit At the end of the existing entry  put the full path to your postgres bin directory   The bin folder should be located in the root of your postgres installation directory  Restart any open command prompts  or to be certain  restart your computer    This should hopefully resolve any problems   For more information see    http   php net manual en install pecl windows php http   webcheatsheet com php install and configure php extsetup

User · Answer

I got this problem too  I have solved this issue already  If u are using Wamp then perform the following steps         Go to wamp64 www bin php php   where   is the php version you are using    Edit file php and uncomment this line by removing the semicolon        extension pdo pgsql to extension pdo pgsql         Save and restart your Wamp server      If it does not work  please check your  env and config database again

User · Answer

This worked for me    sudo apt-get install php-gd php-mysql

User · Answer

sudo apt-get install php7 1-pgsql

User · Answer

The driver came disactivated by default you should active by yourself  after that it will work well  I hope this do

User · Answer

For PDOException  could not find driver for MySQL  and if it is Debian based OS   sudo apt-get -y install php5-mysql

User · Answer

For those wanting to use Postgresql on OpenSuse  and co   try the following   zypper --no-refresh in php5-pgsql

[php] Laravel: Error [PDOException]: Could not Find Driver in PostgreSQL

Examples related to php

Examples related to database

Examples related to postgresql

Examples related to laravel

Examples related to syntax-error