Share via

Create a PostgreSQL DB Server with Basic pricing tier by Geo-Restoring a PostgreSQL DB Server with General Purpose pricing tier

Tim Jin 36 Reputation points
2021-01-12T02:01:10.117+00:00

I get 1 Azure PostgreSQL DB servers: "DBServerA" under subscription "MySubscription" and resource group "MyResourceGroup". "DBServerA" has sku GP_Gen5_2 and its geoRedundant is enabled.

I would like to create a backup PostgreSQL DB servers "DBServerB" (from "DBServerA") which has sku B_Gen5_2 by following commands:
az account set --subscription MySubscription
az configure --defaults group=MyResourceGroup
az postgres server georestore --name "DBServerB" --source-server "DBServerA" --location westus --sku-name B_Gen5_2

These commands report error "cli.azure.cli.core.azclierror : Deployment failed. Correlation ID: XXX. The edition Basic is not a valid edition. Edition cannot be changed by restoring.
Deployment failed. Correlation ID: XXX. The edition Basic is not a valid edition. Edition cannot be changed by restoring"

Does it mean that it's impossible to create a PostgreSQL DB servers with Basic pricing tier by geo-restoring a PostgreSQL DB servers with GP pricing tier directly? (I cannot find documentations mentioning this explicitly)

If yes, any workaround available?

The "DBServerB" would be moved to my testing subscription/resource group as the testing database server by other commands

Azure Database for PostgreSQL

Answer accepted by question author

KalyanChanumolu-MSFT 8,361 Reputation points
2021-01-19T15:28:42.387+00:00

Apologies for the delayed response.
I checked this and figured that it is not supported. Possibly because GeoRedundant backup is not supported for Basic tier.
I am not aware of any workarounds at this time.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

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