Azure DB for Postgres not accessible from Azure App Services

Question

I'm running a Dotnet Web API in a container on Azure App Services (Free tier plan).

In my application, I check the POSTGRES_CONN_STRING environment variable and then use it as a connection string for the database hosted on Azure Database for PostgreSQL.

When I run the application locally after setting the environment variable, it works well. However, in the Azure App Services configuration section, when I set it through the connection strings, it throws an error:

Log from the Log stream in App Services: System.Net.Sockets.SocketException (00000005, 0xFFFDFFFF): Name or service not known

What could be wrong?

skynyrd · Accepted Answer · 2024-02-04 11:12:51Z

0

Looks like Azure does not expose the connection urls as an environment variable, so when I moved POSTGRES_CONN_STRING to Application Setting section instead of Connection String section, it worked.

answered Feb 4, 2024 at 11:12

skynyrd

9824 gold badges16 silver badges38 bronze badges

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

1 Comment

Qiuzman Over a year ago

I am having a heck of a time getting my nodejs app to connect to my PostgreSQL server on azure. I use environment variables in the nodejs(strapi) app for database username, pass, etc. but it does not seem to see the db. You think I need to add a connection string like you as well?

Collectives™ on Stack Overflow

Azure DB for Postgres not accessible from Azure App Services

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related