The backup restore is set to 7 days, but I don't see any restore point in the backup and restore menu.

Question

Hello,
The backup restore is set to 7 days, but I don't see any restore point in the backup and restore menu.

When I try to restore from Overview manu, I get an error:

Only 40% of the storage is used and the database is not overloaded.
Some one could help me?

Answer 1

Hi @Mateusz Gródek,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

If your Azure Database for PostgreSQL Flexible Server has a 7-day backup retention policy but no restore points appear in the Backup and Restore menu, it could be there are no backups available within the retention period.

you can try following steps to troubleshoot:

Check the status of the backup:

You can execute the below mentioned command to verify status of the backups which provides list of backups available for the PostgreSQL flexible server. You can execute this command in Azure CLI.

az postgres flexible-server backup list -g <Resourcegroupname>-n <Servername>

Check the status of the server:

1.Open a command prompt or terminal window.

2.Log in to your Azure account using the 'az login' command.

3.Run the following command to check the status of your PostgreSQL server:

az postgres flexible-server show --resource-group <resource-group-name> --name <server-name>

I would request you to refer the below mentioned link.

https://learn.microsoft.com/en-us/cli/azure/postgres/flexible-server?view=azure-cli-latest

https://learn.microsoft.com/en-us/cli/azure/postgres/flexible-server/backup?view=azure-cli-latest

Replace <resource-group-name> and <server-name> with the appropriate values for your environment. This command returns the current state of the server, which can be one of the following values:

Ready: The server is running and ready to accept connections.

Creating: The server is being created.

Updating: The server is being updated.

Deleting: The server is being deleted.

Failed: The server has encountered an error and cannot be started.

 If the server is not running or is experiencing issues, you may need to resolve these issues before attempting to restore the database.

I hope this information helps. Please do let us know if you have any further queries.

If the answer is helpful, please click "Accept Answer" and "Upvote it".

Answer 2

Hello,

Thank you for your reply. When I run:

az postgres flexible-server backup list -g <Resourcegroupname>-n <Servername>

I got an empty bracket :

[ ]

This is the result informing about the status:

{
  "administratorLogin": <login>,
  "administratorLoginPassword": null,
  "authConfig": {
    "activeDirectoryAuth": "Disabled",
    "passwordAuth": "Enabled",
    "tenantId": null
  },
  "availabilityZone": "1",
  "backup": {
    "backupRetentionDays": 7,
    "earliestRestoreDate": null,
    "geoRedundantBackup": "Disabled"
  },
  "createMode": null,
  "dataEncryption": {
    "geoBackupEncryptionKeyStatus": null,
    "geoBackupKeyUri": null,
    "geoBackupUserAssignedIdentityId": null,
    "primaryEncryptionKeyStatus": null,
    "primaryKeyUri": null,
    "primaryUserAssignedIdentityId": null,
    "type": "SystemManaged"
  },
  "fullyQualifiedDomainName": <Servername>
,
  "highAvailability": {
    "mode": "Disabled",
    "standbyAvailabilityZone": null,
    "state": "NotEnabled"
  },
  "id": <subscription>,
  "identity": null,
  "location": "West Europe",
  "maintenanceWindow": {
    "customWindow": "Disabled",
    "dayOfWeek": 0,
    "startHour": 0,
    "startMinute": 0
  },
  "minorVersion": "15",
  "name": <Servername>,
  "network": {
    "delegatedSubnetResourceId": null,
    "privateDnsZoneArmResourceId": null,
    "publicNetworkAccess": "Enabled"
  },
  "pointInTimeUtc": null,
  "privateEndpointConnections": null,
  "replica": {
    "capacity": 5,
    "promoteMode": null,
    "promoteOption": null,
    "replicationState": null,
    "role": "Primary"
  },
  "replicaCapacity": 5,
  "replicationRole": "Primary",
  "resourceGroup": <resourceGroup>,
  "sku": {
    "name": "Standard_D2ds_v5",
    "tier": "GeneralPurpose"
  },
  "sourceServerResourceId": null,
  "state": "Ready",
  "storage": {
    "autoGrow": "Enabled",
    "iops": 5000,
    "storageSizeGb": 512,
    "throughput": null,
    "tier": "P30",
    "type": ""
  },
  "systemData": {
    "createdAt": "2023-10-13T11:47:50.014143+00:00",
    "createdBy": null,
    "createdByType": null,
    "lastModifiedAt": null,
    "lastModifiedBy": null,
    "lastModifiedByType": null
  },
  "tags": {},
  "type": "Microsoft.DBforPostgreSQL/flexibleServers",
  "version": "13"
}

Can you advise me on what I can improve?