Share via

Azure Postgres Flexible high availlability is not enabling

Nitin Parmar-Tss consultancy 71 Reputation points
2023-07-03T13:56:42.31+00:00

Hi Team,

I want to enable HA (high availability) in Postgres Flexible Server, but it's giving an error.

Current infra is General Purpose, D2ds_v4, 2 vCores, 8 GB of RAM, and 128 GB of storage.

User's image

User's image

Azure Database for PostgreSQL
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
36 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 82,041 Reputation points Microsoft Employee
    2023-07-04T04:23:34.9666667+00:00

    @Nitin Parmar-Tss consultancy - Thanks for the question and using MS Q&A platform.

    This is an excepted behaviour when you already deployed non-HA servers, you cannot directly enable zone redundant HA on the server.

    User's image

    Error: 

    Invalid value given for parameter StandbyAvailabilityZone,availabilityZone. Specify a valid parameter value. (Code: InvalidParameterValue)

    User's image

    There are Azure regions that do not support availability zones. If you have already deployed non-HA servers, you cannot directly enable zone redundant HA on the server, but you can perform restore and enable HA in that server.

    Following steps shows how to enable Zone redundant HA for that server.

    1. From the overview page of the server, click Restore to perform a PITR. Choose Latest restore point.
    2. Choose a server name, availability zone.
    3. Click Review+Create".
    4. A new Flexible server will be created from the backup.
    5. Once the new server is created, from the overview page of the server, follow the guide to enable HA.
    6. After data verification, you can optionally delete the old server.
    7. Make sure your clients connection strings are modified to point to your new HA-enabled server.

    For more details, refer to Enabling Zone redundant HA after the region supports AZ.

    Hope this helps. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.