Connection time out when trying to connect to Azure Postgresql DB

MAHESHI GUNARATNE 0 Reputation points
2023-08-28T23:08:36.4866667+00:00

I get this issue when trying to connect to the azure database.The server is currently in a disabled state. Please wait for the operation to complete.

You can refresh to check the status. Reach out to Microsoft support if the operation is taking too long.

Azure Database for PostgreSQL
{count} votes

2 answers

Sort by: Most helpful
  1. RahulRandive 10,486 Reputation points Volunteer Moderator
    2023-08-28T23:24:25.1466667+00:00

    Hi MAHESHI GUNARATNE
    Please verify whether your subscription itself is in a disabled state, as this could potentially result in the server being disabled.

    Your Azure subscription can get disabled because your credit has expired or if you reached your spending limit. It can also get disabled if you have an overdue bill, hit your credit card limit, or because the Account Administrator canceled the subscription

    If that's the case, you might need to activate the subscription. Here is a document for your reference.

    https://learn.microsoft.com/en-us/azure/cost-management-billing/manage/subscription-disabled

    Thank you!

    0 comments No comments

  2. SSingh-MSFT 16,371 Reputation points Moderator
    2023-08-29T09:45:37.5733333+00:00

    Hi MAHESHI GUNARATNE •,

    Welcome to Microsoft Q&A forum and thanks for using Azure Services.

    As I understand, you are getting connection timed out when trying to connect to Azure PostgreSQL Database.

    We are sorry about the inconvenience you are facing.

    Could you please share below information to us:

    Is the server Data Encrypted with CMK?

    If yes, make sure these requirements are met https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-data-encryption#requirements-for-configuring-data-encryption-for-azure-database-for-postgresql-flexible-server and check if connection to Key Vault exists.

    What is the Region in which this server was created?

    What is the configuration of the Flexible Server?

    Transient errors occur when maintenance is performed, the system encounters an error with the hardware or software, or you change the vCores or service tier of your server. The Azure Database for PostgreSQL service has built-in high availability and is designed to mitigate these types of problems automatically. However, your application loses its connection to the server for a short period of time of typically less than 60 seconds at most. Some events can occasionally take longer to mitigate, such as when a large transaction causes a long-running recovery.

    Also refer to https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-limits

    https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-troubleshoot-common-connection-issues

    Thanks.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.