Read replica creation for Azure Database for Postgres flexible server via Azure CLI

ofranz 10

When trying to replicate a server in the region West Europa the CLI responds with the following error:

Replica can only be created for multi-availability zone regions. The location of the source server is in a single availability zone region.

The command used:

az postgres flexible-server replica create  --replica-name testReplicaServer -g tt-bi --source-server sourceServer --zone westeuropa

The replica creation itself works via the Azure Portal UI for the same server.

ShaktiSingh-MSFT 15,321 Reputation points

2023-03-23T08:48:29.9066667+00:00

Hi @ofranz ,

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

As I understand, you have tried to perform replica creation of Azure Database for Postgres Flexible Server via Azure CLI where error came and via portal it was done successfully in West Europe region.

Let me know if my understanding is not aligned to what is expected.

Thank you for reporting this behavior in the replication, I will look into this issue in the Azure Database for Postgres Flexible Server instance and will take necessary action.

I will keep you posted about the progress. Do let us know if you have further queries.

Thank you.
ofranz 10 Reputation points

2023-03-28T06:58:52.58+00:00

Your summary is correct. Thanks for looking into this!
ShaktiSingh-MSFT 15,321 Reputation points

2023-03-28T11:30:56.0833333+00:00

Thanks ofranz.

Could you please let us know the configuration used for your Azure PostgreSQL Flexible Server Database so that I can reproduce the scenario.

Read replica is supported only for General Purpose and Memory Optimized pricing tier.

Thanks in advance.
ofranz 10 Reputation points

2023-03-30T14:45:55.64+00:00

That's correct. I'm using a General Purpose instance deployed in West Europe.

Specific Configuration: General Purpose, D16s_v3, 16 vCores, 64 GiB RAM, 256 GiB storage

Postgres Version: 12.13

Location: West Europe

Thanks for looking into this!
ShaktiSingh-MSFT 15,321 Reputation points

2023-03-31T06:59:58.4+00:00

Hi ofranz.,

Thanks for providing the details.

After reproducing the scenario, I find that you are correct in observing the trait difference via Portal and CLI.

I am checking on this behavior with the internal team and will update you about the progress. Have a good day!
ShaktiSingh-MSFT 15,321 Reputation points

2023-04-05T06:40:16.2533333+00:00

Hi @ofranz , Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.
ShaktiSingh-MSFT 15,321 Reputation points

2023-04-06T09:10:09.3733333+00:00

Hi ofranz., As communicated by internal team, the issue has been fixed now. Could you please check at your end if you are able to perform replica creation of Azure Database for Postgres Flexible Server via Azure CLI.

Or Set availability zone for replica server same as zone of source server as long as the region supports that AZ, else default to No preference. Thank you

2 answers

ShaktiSingh-MSFT 15,321 Reputation points

2023-04-03T05:54:28.7533333+00:00

Hi @ofranz ,

Thanks for your patience and for reporting the behavior.

I have checked with the internal team regarding the Read replica creation for Azure Database for Postgres flexible server via Azure CLI., it has been communicated that it is a known issue and would be resolved soon.

For now, we request you to use Azure portal for replication.

In case of further questions, please let us know.

Many thanks for your contribution.

Thank you.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Sahu, Ayush 0 Reputation points

2023-10-02T07:24:59.4966667+00:00
Hi,

I am also facing similar issue, where I can create a replica with same name but with azure cli I am getting error as below :

az postgres flexible-server replica create --replica-name ${EUW_POSTGRES_NAME} --resource-group ${EUW_RESOURCE_GROUP} \ --source-server ${EUN_POSTGRES_ID} --location ${EUW_LOCATION} \ --subnet "${EUW_SUBNET_ID}" --zone 3 Specified server name is already used.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Read replica creation for Azure Database for Postgres flexible server via Azure CLI

2 answers

Your answer