This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 32%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Hello,
I have trouble connecting to the Azure postgres database from python. I am following the guide here - https://learn.microsoft.com/cs-cz/azure/postgresql/connect-python
But the psycopg2 and SQLalchemy throw me the same error:
OperationalError: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
I am able to connect to the instance by other client tools like dbeaver but from python it does not work.
When I investigate in Postgres logs I can see that the server actually authorized the connection but the next line says
could not receive data from client: An existing connection was forcibly closed by the remote host.
psycopg's version is 2.8.5
Azure Postgres region is in West Europe
Do you have any suggestion on what to try to debug this?
Thank you!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Hi @Petr Svec , it looks like there is no problem on Azure PostgreSQL as this issue has been observed frequently with psycopg2 version 2.8.5.
Is it possible for you to once try with lower version of psycopg2(2.7.4)?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Just checking in to see if you were able to try with a different version of psycopg2.
If upon further investigation, you find a solution to your issue, please do post it here and mark it as answer.
It might be beneficial to other community members reading this thread.
Thank you!
@AnuragSharma-MSFT,
Thank you for reaching out. I tried other versions of psycopg2 without any luck.
However, it seems like the issue was somehow related to Azure West Europe as it got resolved by itself over time. When I tried it yesterday, the same library setup (psycopg2 2.8.5) worked as expected.
The issue resolved itself. Guess there must have something happened on the Azure West Europe side because when I tried the same setup again a few days later it started working.
@KalyanChanumolu-MSFT , @AnuragSharma-MSFT , thank you for commenting.
P.