Query to find out when the last time a database backup was taken in PostgreSQL

Question

Looking for a query to find out when the last time a database backup was taken in Azure Database for PostgreSQL flexible server.

Answer 1

Hi Naveen Kumar Kakarla (Quadrant Resource)

I think you can't query backup information in the same way as you might on a traditional SQL Server.

but you can check the last backup time using the Azure CLI. ill guide you on how to check this using the CLI

az postgres flexible-server show --resource-group YourResourceGroup --name YourPostgreSQLServer --query 'backupInfo.earliestRestoreDate'

Thi command backupInfo.earliestRestoreDate property, which represents the timestamp of the last backup time.

If this helps kindly accept the answer thanks much.