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 !
Please or to participate in this conversation.