PostgreSQL HA Options in Azure

Question

PostgreSQL HA Options in Azure

Bruce Dungy 21

I am somewhat new to utilizing PostgreSQL in Azure. I noticed that when using the Gateway/Proxy, high availability seems to be built in. If I use a private link, does the same apply? I see I can create high availability with Flexible Server but I'm not sure of the behavior for GP Server. Also, if I create a read replica in a second region, is the role transition of the read replica to a primary automatic?

Anurag Sharma 17,631 Reputation points

2022-02-28T06:12:55.283+00:00

Hi @Bruce Dungy , welcome to Microsoft Q&A forum.

Could you please confirm if you are just referring to Flexible Server or both Flexible and Single Server? Just to add 'A flexible server doesn't support Azure Private Link. Instead, it uses virtual network injection to make the flexible server available within a virtual network.'. HA is still available in case of Private access through Virtual network and Private DNS zone integration as well.

Also please clarify a little more on 'role transition of the read replica to a primary automatic'.
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2022-03-04T21:39:29.497+00:00

@Bruce Dungy Could you please clarify the above question asked by @AnuragSharma-MSFT

Regards,
Oury
Bruce Dungy 21 Reputation points

2022-03-04T23:23:19.167+00:00

Yes, I was referring to single server. Assuming the zone where single server is running crashes, do Azure automatically start another single server in a separate zone and move the private link as well?

Thanks,

Bruce

Accepted answer

0 additional answers

Your answer

Anurag Sharma 17,631 Reputation points

2022-02-28T06:12:55.283+00:00

Hi @Bruce Dungy , welcome to Microsoft Q&A forum.

Could you please confirm if you are just referring to Flexible Server or both Flexible and Single Server? Just to add 'A flexible server doesn't support Azure Private Link. Instead, it uses virtual network injection to make the flexible server available within a virtual network.'. HA is still available in case of Private access through Virtual network and Private DNS zone integration as well.

Also please clarify a little more on 'role transition of the read replica to a primary automatic'.
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2022-03-04T21:39:29.497+00:00

@Bruce Dungy Could you please clarify the above question asked by @AnuragSharma-MSFT

Regards,
Oury
Bruce Dungy 21 Reputation points

2022-03-04T23:23:19.167+00:00

Yes, I was referring to single server. Assuming the zone where single server is running crashes, do Azure automatically start another single server in a separate zone and move the private link as well?

Thanks,

Bruce

Answer 1

Thanks for replying back.

Private Endpoints and links are highly available resources. However, since they are regional resources, any Azure region outage can impact the availability. To achieve availability in case of regional failures, multiple PEs connected to same destination resource could be deployed in different regions. This way if one region goes down, you can still route the traffic for your recovery scenarios through PE in different region to access the destination resource.

Azure Private Link frequently asked questions (FAQ)

SLA for Azure Private Link

Please let us know if you have any further queries and we can continue the discussion.

Share via

PostgreSQL HA Options in Azure

0 additional answers

Your answer