azure database for postgres and laravel application connection

Question

i have created azure database for postgres and uploaded my database there. and give the connection details in local database IDE and am getting the connection and works smoothly. but when i connect to azure database using local laravel application am getting

{"message":"Currencies can\u2019t be retrievedSQLSTATE[08006] [7] FATAL:  password authentication failed for user \"postgres\"\nFATAL:  password authentication failed for user \"postgres\" (Connection: pgsql, SQL: select * from \"currencies\")"}  error. given the correct password and user name

Answer 1

Hi
Milestone IT •,

Welcome to Microsoft Q&A forum.

As I understand, you are getting error of password authentication failed when connecting to azure database postgresql using local laravel application.

Please refer to similar Q&A post which could be helpful:

https://learn.microsoft.com/en-us/answers/questions/1443134/how-to-connect-postgres-db-and-laravel-app-hosted

Also refer to https://learn.microsoft.com/en-us/azure/postgresql/single-server/connect-php for more details.

Let us know if this helped.

Thanks