az postgres flexible-server create ignores location of default group

[guettli]

Describe the bug

Command Name
az postgres flexible-server create

My default group orderkit has location "western europe". Above command uses the default group, but creates
a server with location US. This makes no sense. It should take the location from the default group.

Errors:

guettli@yoga15:~/fun-env/code$ az postgres flexible-server create
Command group 'postgres flexible-server' is in preview and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Checking the existence of the resource group 'orderkit'...
Resource group 'orderkit' exists ? : True 
Creating new Vnet "Vnet485832690" in resource group "orderkit"
Creating new Subnet "Subnet485832690" in resource group "orderkit"
Creating a private dns zone server485832690.private.postgres.database.azure.com..
Creating PostgreSQL Server 'server485832690' in group 'orderkit'...
Your server 'server485832690' is using sku 'Standard_D2s_v3' (Paid Tier). Please refer to https://aka.ms/postgres-pricing for pricing details
Creating PostgreSQL database 'flexibleserverdb'...
Make a note of your password. If you forget, you would have toreset your password with "az postgres flexible-server update -n server485832690 -g orderkit -p <new-password>".
{
  "connectionString": "postgresql://xx@server485832690.postgres.database.azure.com/postgres?sslmode=require",
  "host": "server485832690.postgres.database.azure.com",
  "id": "/subscriptions/63ce289c-d124-4a41-868d-7a5d220b295e/resourceGroups/orderkit/providers/Microsoft.DBforPostgreSQL/flexibleServers/server485832690",
  "location": "East US",
  "password": "XXXXX",
  "resourceGroup": "orderkit",
  "skuname": "Standard_D2s_v3",
  "subnetId": "/subscriptions/63ce289c-d124-4a41-868d-7a5d220b295e/resourceGroups/orderkit/providers/Microsoft.Network/virtualNetworks/Vnet485832690/subnets/Subnet485832690",
  "username": "xxx",
  "version": "12"

Environment Summary

Linux-5.4.0-72-generic-x86_64-with-debian-bullseye-sid
Python 3.6.10
Installer: DEB

azure-cli 2.23.0

Additional Context

[ghost]

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @sunilagarwal, @lfittl-msft, @sr-msft, @niklarin.

Issue Details

---

Describe the bug

Command Name
az postgres flexible-server create

My default group orderkit has location "western europe". Above command uses the default group, but creates
a server with location US. This makes no sense. It should take the location from the default group.

Errors:

guettli@yoga15:~/fun-env/code$ az postgres flexible-server create
Command group 'postgres flexible-server' is in preview and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Checking the existence of the resource group 'orderkit'...
Resource group 'orderkit' exists ? : True 
Creating new Vnet "Vnet485832690" in resource group "orderkit"
Creating new Subnet "Subnet485832690" in resource group "orderkit"
Creating a private dns zone server485832690.private.postgres.database.azure.com..
Creating PostgreSQL Server 'server485832690' in group 'orderkit'...
Your server 'server485832690' is using sku 'Standard_D2s_v3' (Paid Tier). Please refer to https://aka.ms/postgres-pricing for pricing details
Creating PostgreSQL database 'flexibleserverdb'...
Make a note of your password. If you forget, you would have toreset your password with "az postgres flexible-server update -n server485832690 -g orderkit -p <new-password>".
{
  "connectionString": "postgresql://xx@server485832690.postgres.database.azure.com/postgres?sslmode=require",
  "host": "server485832690.postgres.database.azure.com",
  "id": "/subscriptions/63ce289c-d124-4a41-868d-7a5d220b295e/resourceGroups/orderkit/providers/Microsoft.DBforPostgreSQL/flexibleServers/server485832690",
  "location": "East US",
  "password": "XXXXX",
  "resourceGroup": "orderkit",
  "skuname": "Standard_D2s_v3",
  "subnetId": "/subscriptions/63ce289c-d124-4a41-868d-7a5d220b295e/resourceGroups/orderkit/providers/Microsoft.Network/virtualNetworks/Vnet485832690/subnets/Subnet485832690",
  "username": "xxx",
  "version": "12"

Environment Summary

Linux-5.4.0-72-generic-x86_64-with-debian-bullseye-sid
Python 3.6.10
Installer: DEB

azure-cli 2.23.0

Additional Context

Author:	guettli
Assignees:	-
Labels:	PostgreSQL, Service Attention, needs-triage, question
Milestone:	-

[yonzhan]

route to service team

[DaeunYim]

Hi @guettli
Thanks for reporting this issue.

After internal discussion, we have decided to change the default location to resource group location.

Originally, setting default location to EastUS was to make sure we deploy the server to pg server supported regions but since this can cause confusion to customers, we decided make the change as you requested. Please expect 1-2 month delay until this fix is included in the next release.

Meanwhile, please use --location (-l) parameter explicitly to deploy the server to your region.

Thanks you.

[RakeshMohanMSFT]

@guettli This is fixed now.