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

by

Be sure to configure the 'default' key in app/config/database.php

For postgres, this would be 'default' => '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:

  1. System Properties -> Advanced tab -> Environment Variables
  2. In ‘System variables’ group on lower half of window, scroll through and find the PATH entry.
  3. Select it and click Edit
  4. 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.
  5. Restart any open command prompts, or to be certain, restart your computer.

This should hopefully resolve any problems. For more information see:

More Related Contents:

  1. Laravel one to many relation with a one to one relation
  2. How to use multiple databases in Laravel
  3. PDOException SQLSTATE[HY000] [2002] No such file or directory
  4. Get the Last Inserted Id Using Laravel Eloquent
  5. Proper Repository Pattern Design in PHP?
  6. Laravel – Database, Table and Column Naming Conventions?
  7. Laravel nested relationships
  8. laravel 4 custom named password column
  9. Laravel Change Connection Dynamically
  10. inserting image in database using php [closed]
  11. Target class controller does not exist – Laravel 8
  12. How do I get the query builder to output its raw SQL query as a string?
  13. How to query between two dates using Laravel and Eloquent?
  14. Difference between method calls $model->relation(); and $model->relation;
  15. Laravel, sync() – how to sync an array and also pass additional pivot fields?
  16. PHP expects T_PAAMAYIM_NEKUDOTAYIM?
  17. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  18. pg_query result contains strings instead of integer, numeric
  19. PATCH and PUT Request Does not Working with form-data
  20. Generating a single Entity from existing database using symfony2 and doctrine
  21. Script @php artisan package:discover handling the post-autoload-dump event returned with error code 255
  22. Setting document root for Laravel project on Apache virtual host
  23. Laravel preg_match(): No ending delimiter ‘/’ found
  24. Class ‘App\Http\Controllers\admin\Auth’ not found in Laravel 5
  25. How to query all the GraphQL type fields without writing a long query?
  26. Parse error: syntax error, unexpected ‘(‘, expecting ‘,’ or ‘;’ in
  27. Disable rate limiter in Laravel?
  28. Laravel – display a PDF file in storage without forcing download?
  29. mysql_insert_id alternative for postgresql
  30. Laravel ORM from self referencing table get N level hierarchy JSON

Leave a Comment