Why application in Azure Container Instance cannot connect to Azure SQL DB for PostgreSQL?

Question

I have Python application in Azure Container Instance, which tries establish connection to Azure DB for PostgreSQL, but failing. Azure DB firewall is open for Azure services. Connection works fine, when application is connecting from local machine docker.

I wonder what is the problem?

psql: error: FATAL:  password authentication failed for user "myuser"
'sales.Customers' table is unavailable - sleeping
* Could not resolve host: hslotp
* Closing connection 0
OTP is unavailable - sleeping

Please Check this stackoverflow.com/questions/43426652/… and dba.stackexchange.com/questions/131129/… thread it may help you. — RahulKumarShaw
– RahulKumarShaw, Commented Dec 29, 2021 at 5:13
can you share the connection string format you are trying, some code — KarthikBhyresh-MT
– KarthikBhyresh-MT, Commented Jan 5, 2022 at 11:24

KarthikBhyresh-MT · Accepted Answer · 2022-01-05 11:50:14Z

1

Have you checked the ports match, here is something you can verify from Troubleshoot connection issues to Azure Database for PostgreSQL

make sure you have the latest of psycopg2 release or atleast above 2.8.0

Also, the connection string should looks like below. Make sure you get Server name and login details from Azure portal.

postgresql://user:password@container_name:5432?sslmode=disable

Refer: thon to connect and query data in Azure Database for PostgreSQL

answered Jan 5, 2022 at 11:50

KarthikBhyresh-MT

5,1142 gold badges7 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Why application in Azure Container Instance cannot connect to Azure SQL DB for PostgreSQL?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related