sarathiscookie's avatar

“PDOException could not find driver” in laravel migration with postgresql

I have three databases for my project. When I try Laravel migration with PostgreSQL. I am getting some error. But Laravel migration with other mysql databases is okay. I am using XAMPP and Windows 10. Could you please check below code and correct me? Error [PDOException] could not find driver Database return [ 'fetch' => PDO::FETCH_CLASS, 'default' => env('DB_CONNECTION', 'mysql_shop'), 'connections' => [ 'sqlite' => [ 'driver' => 'sqlite', 'database' => database_path('database.sqlite'), 'prefix' => '', ], 'mysql_cms' => [ 'driver' => 'mysql', 'host' => env('DB_CONTAO_HOST', 'localhost'), 'database' => env('DB_CONTAO_DATABASE', 'forge'), 'username' => env('DB_CONTAO_USERNAME', 'forge'), 'password' => env('DB_CONTAO_PASSWORD', ''), 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => false, 'engine' => null, ], 'mysql_shop' => [ 'driver' => 'mysql', 'host' => env('DB_SHOP_HOST', 'localhost'), 'database' => env('DB_SHOP_DATABASE', 'forge'), 'username' => env('DB_SHOP_USERNAME', 'forge'), 'password' => env('DB_SHOP_PASSWORD', ''), 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => false, 'engine' => null, ], 'pgsql' => [ 'driver' => 'pgsql', 'host' => env('DB_PGSQL_HOST', 'localhost'), 'database' => env('DB_PGSQL_DATABASE', 'maindb'), 'username' => env('DB_PGSQL_USERNAME', 'postgres'), 'password' => env('DB_PGSQL_PASSWORD', 'postgres'), 'charset' => 'utf8', 'prefix' => '', 'schema' => env('DB_PGSQL_SCHEMA', 'fes'), ], 'sqlsrv' => [ 'driver' => 'sqlsrv', 'host' => env('DB_HOST', 'localhost'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'charset' => 'utf8', 'prefix' => '', ], ] Migration code use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreatePasswordResetsTable extends Migration { public function up() { Schema::connection('pgsql')->create('fes.password_resets', function (Blueprint $table) { $table->string('email')->index(); $table->string('token')->index(); $table->timestamp('created_at'); }); } public function down() { Schema::connection('pgsql')->drop('fes.password_resets'); } }

0 likes
0 replies

Please or to participate in this conversation.