Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,427 questions
Connect to Azure Database for PostgreSQL flexible server from SQL Shell
![](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(128, 15%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Vidar
21
Reputation points
hi
I'm trying to connect to my postgres flexible server from my office PC using PSQL shell. That's it - nothing complex, just complete beginner stuff here! I won't even get onto Navicat here...
When I get to the enter username: and press return, I get this error:
error: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "foo-flex-server.postgres.database.azure.com" (23.38.145.57) and accepting TCP/IP connections on port 5432?
I have added my IP of my office/dev PC computer to the whitelist too, but this doesn't seem to have changed anything.
Don't know where to start with this one. Any ideas?
Azure Database for PostgreSQL
{count} votes
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator2021-08-10T16:23:34.697+00:00 Hi @Vidar Thank you for posting your question. Which of the networking options have you created your Azure PostgreSQL server Private access (VNet integration) or Public access (allowed IP addresses)?
Regards,
Oury -
Vidar 21 Reputation points
2021-08-10T16:27:37.727+00:00 Public access.
II think I've sorted it though - I have tried on my own personal PC and installed on C drive the PSQL command line and it seems to work.
I installed the PSQL command line on my D drive and I don't think it liked that at all! Complaining about the "system can't find the path" (despite messing about with Environment Variables, something that you don't have to bother with ordinarily with).
The issue is with our company's firewall which seems to blocking port 5432 - I'm almost 99% sure that is the problem.
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
2021-08-10T17:08:07.57+00:00 Hi @Vidar I am glad it worked. Please feel free to reach out if you have additional queries.
Regards,
Oury
Sign in to comment
Sign in to answer