Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Laravel Migration Postgres error

HI i want to connect Laravel with postgres database.

when i run

php artisan migrate

it gives me this error.

[Illuminate\Database\QueryException]                                                                                                                                                    
SQLSTATE[08006] [7] expected authentication request from server, but received J (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations)  



[Doctrine\DBAL\Driver\PDOException]                                              
SQLSTATE[08006] [7] expected authentication request from server, but received J  
like image 439
Romantic Dev Avatar asked Feb 02 '17 00:02

Romantic Dev


2 Answers

To me the problem was that I forget to change the port from 3306 to 5432

like image 146
Carlos Leyan Avatar answered Sep 30 '22 03:09

Carlos Leyan


Please check that you have entered correct credentials for the pgsql database.

Thanks!

like image 20
vivek k Avatar answered Sep 30 '22 02:09

vivek k