Share via

Azure PostgreSQL Database Backup

Sonal Patel 40 Reputation points
2024-10-21T18:49:01.0233333+00:00

The documentation on this page https://zcusa.951200.xyz/en-us/training/modules/backup-restore-azure-sql/2-protect-database-with-backup focuses on Azure SQL Database backups. Does this information also apply to Azure Database for PostgreSQL? Specifically, I'm interested in knowing if PostgreSQL databases in Azure Single Server and Flexible Server also utilise full, differential, and transaction log backups to enable point-in-time restores.

This question is related to the following Learning Module

Azure Database for PostgreSQL
0 comments
Accepted answer
  1. Oury Ba-MSFT 19,831 Reputation points Microsoft Employee
    2024-10-21T21:08:41.6+00:00

    @Sonal Patel Thank you for reaching out.

    The information in this Learning Module applies only to Azure SQL Database. For Azure PostgreSQL flexible server, I would suggest reviewing this doc https://zcusa.951200.xyz/en-us/azure/postgresql/flexible-server/concepts-backup-restore. Please note that Azure PostgreSQL single server is in retirement phase, we are strongly encouraging customers to migrate to Flexible server.

    Azure Database for PostgreSQL Flexible Server does not support traditional full and differential backups. Instead, it uses snapshot backups and transaction log backups to enable point-in-time restores. For more information on back up for Azure PostgreSQL, please review the doc I shared above.

    Please don't forget to mark as accept answer if the reply was helpful. Otherwise comment below with any additional questions.

    Regards,

    Oury

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

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