Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

GotExx's avatar

password authentication failed for user "specificuser" for migrate

Hello,

I would like to deploy my project on a remote VPs. So I installed apache2 and postgresql 11.

After having created a specific user for the connection of my project, impossible to do a DB migration, I always get SQLSTATE [08006] [7] FATAL: password authentication failed for user "specificuser". FATAL: password authentication failed for user 'specificuser' (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')

However I can connect to the command line with the psql -U specifictuser -d specificdb command.

The user specifiuser is a Unix user AND postgresql.

My .env

DB_CONNECTION=pgsql DB_HOST=localhost DB_PORT=5432 DB_DATABASE=specificdb DB_USERNAME=specificuser DB_PASSWORD=verygoodpassword

Thank's for help !

0 likes
0 replies

Please or to participate in this conversation.