Laravel Migration Postgres error

Question

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

no @Serj.by i moved to mysql let me know if you find the solution — FULL STACK DEV
– FULL STACK DEV, Commented Jun 22, 2017 at 9:24

Carlos Leyan · Accepted Answer · 2018-04-20 13:18:33Z

6

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

answered Apr 20, 2018 at 13:18

Carlos Leyan

611 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

vivek k · Accepted Answer · 2017-02-03 08:59:36Z

1

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

Thanks!

answered Feb 3, 2017 at 8:59

vivek k

316 bronze badges

Comments

Muchtarpr · Accepted Answer · 2017-02-21 06:26:46Z

1

check your file on :
.env
config/database

did you type correct data for :

DB_CONNECTION=
DB_HOST=
DB_PORT=
DB_DATABASE=
DB_USERNAME=
DB_PASSWORD=

and

'default' => env('DB_CONNECTION', 'pgsql'),

answered Feb 21, 2017 at 6:26

Muchtarpr

971 silver badge3 bronze badges

Collectives™ on Stack Overflow

Laravel Migration Postgres error

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related