Azure Single Server Point in Time Restore

Question

Hello, I've previously asked a similar question but recieved information for Azure Flexible Servers, not Single Server which I was also wanted to query about.

The documentation on this page https://learn.microsoft.com/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 also utilise full, differential, and transaction log backups to enable point-in-time restores.

This question is related to the following Learning Module

Answer 1

Hi Sonal Patel,

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

In addition to the above answer provided by @hossein jalilian,

Azure Database for PostgreSQL servers are backed up periodically to enable Restore features. Using this feature you may restore the server and all its databases to an earlier point-in-time, on a new server. You make the choice between configuring your server for either locally redundant backups or geographically redundant backups at server creation.

I request you to refer the below mentioned link.

https://docs.azure.cn/en-us/postgresql/single-server/how-to-restore-server-portal#point-in-time-restore

Note: Azure Database for PostgreSQL - Single Server is going to deprecated hence we strongly recommend you to upgrade your Azure Database for PostgreSQL Single Server to Azure Database for PostgreSQL - Flexible Server.

I hope, This response will address your query and helped you to overcome on your challenges.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

Thanks for posting your question in the Microsoft Q&A forum.

The backup and restore mechanisms for Azure Database for PostgreSQL - Single Server differ from those of Azure SQL Database. Instead of using the terms full, differential, and transaction log backups, PostgreSQL employs snapshot backups of data files and transaction log backups, which occur when the write-ahead log (WAL) is archived. It supports point-in-time restore within a configured retention period, which defaults to 7 days but can be extended to 35 days. Backups are encrypted and stored in either zone-redundant or locally redundant storage, with geo-redundant options available for certain tiers. However, backups cannot be exported for use outside of Azure Database for PostgreSQL, necessitating tools like pg_dump for data export. Additionally, the service provides business continuity features such as read replicas for disaster recovery. Notably, Azure Database for PostgreSQL - Single Server is set to retire on March 28, 2025, prompting a recommended migration to Azure Database for PostgreSQL - Flexible Server for future needs.

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful