Got it — with HA not enabled, this narrows down a lot.
Why you’re getting ResourceNotFound
In your CLI error, you’re passing the FQDN as the server name:
psql-#.postgres.database.azure.com
But az postgres flexible-server ... --name expects the resource name only, e.g.:
psql-#
If you include .postgres.database.azure.com, Azure Resource Manager won’t find a resource with that name, so you get ResourceNotFound. (Your earlier notes also show the same pattern.)
Fix it: run these in order
- Make sure you’re in the right subscription
az account show --query "{name:name, id:id}" -o json
az account set --subscription "<subscription-id-or-name>"
List the flexible servers in that resource group
az postgres flexible-server list -g rg-# -o table
This will show the actual server resource name(s). Use exactly what appears under Name.
Then “show” using the short name
az postgres flexible-server show -g rg-# -n psql-#
If that works, you can also check current lifecycle/provisioning state:
az postgres flexible-server show -g rg-# -n psql-# --query "{state:state, provisioningState:provisioningState}" -o json
About “no backup available after >7 days”
That’s consistent with Azure’s default backup retention:
Default retention is 7 days, configurable up to 35 days. ([Microsoft Learn](https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/concepts-backup-restore?utm_source=chatgpt.com"Backup and restore in Azure Database for PostgreSQL"))
So if your retention was left at default 7 days, and you’re now past that window, PITR restore points older than 7 days won’t be available.
You can verify what your server was configured for (once show works):
az postgres flexible-server show -g rg-# -n psql-# --query "backup" -o json
“Start is running but not Ready yet”
That usually means the resource is in a transitional provisioningState (Starting / Updating / Repairing) and the data plane may still be coming up. The best thing you can do right now is keep checking state and activity:
Activity Log in portal (look for Start/Stop, maintenance, failures)
CLI:
az monitor activity-log list --resource-group rg-# --max-events 20 -o table
If you still get ResourceNotFound even with the short name
Then it’s almost always one of these:
wrong subscription (most common)
wrong resource group
the server was deleted/recreated and you’re using an old name
you’re logged into a different tenant
The list -g rg-# step above will reveal that immediately.
If you paste the output of:
az postgres flexible-server list -g rg-# -o table
(Ignore/substitute sensitive bits), I’ll tell you exactly what name to use and whether Azure currently thinks it’s “Starting”, “Ready”, or stuck again.Got it — with HA not enabled, this narrows down a lot.
Why you’re getting ResourceNotFound
In your CLI error, you’re passing the FQDN as the server name:
psql-#.postgres.database.azure.com
But az postgres flexible-server ... --name expects the resource name only, e.g.:
psql-#
If you include .postgres.database.azure.com, Azure Resource Manager won’t find a resource with that name, so you get ResourceNotFound. (Your earlier notes also show the same pattern.)
Fix it: run these in order
Make sure you’re in the right subscription
az account show --query "{name:name, id:id}" -o json
az account set --subscription "<subscription-id-or-name>"
List the flexible servers in that resource group
az postgres flexible-server list -g rg-# -o table
This will show the actual server resource name(s). Use exactly what appears under Name.
Then “show” using the short name
az postgres flexible-server show -g rg-# -n psql-#
If that works, you can also check current lifecycle/provisioning state:
az postgres flexible-server show -g rg-# -n psql-# --query "{state:state, provisioningState:provisioningState}" -o json
About “no backup available after >7 days”
That’s consistent with Azure’s default backup retention:
Default retention is 7 days, configurable up to 35 days. ([Microsoft Learn](https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/concepts-backup-restore?utm_source=chatgpt.com"Backup and restore in Azure Database for PostgreSQL"))
So if your retention was left at default 7 days, and you’re now past that window, PITR restore points older than 7 days won’t be available.
You can verify what your server was configured for (once show works):
az postgres flexible-server show -g rg-# -n psql-# --query "backup" -o json
“Start is running but not Ready yet”
That usually means the resource is in a transitional provisioningState (Starting / Updating / Repairing) and the data plane may still be coming up. The best thing you can do right now is keep checking state and activity:
Activity Log in portal (look for Start/Stop, maintenance, failures)
CLI:
az monitor activity-log list --resource-group rg-# --max-events 20 -o table
If you still get ResourceNotFound even with the short name
Then it’s almost always one of these:
wrong subscription (most common)
wrong resource group
the server was deleted/recreated and you’re using an old name
you’re logged into a different tenant
The list -g rg-# step above will reveal that immediately.
If you paste the output of:
az postgres flexible-server list -g rg-# -o table
(Ignore/substitute sensitive bits), I’ll tell you exactly what name to use and whether Azure currently thinks it’s “Starting”, “Ready”, or stuck again.