Purging and Backup in Microsoft Azure

Question

Could you please provide some insight about how purging and backup mechanism can be effectively done in Azure Postgres. I am using flyway for DML and DDL operations.. Is it possible to do through flyway?

Answer 1

Azure Database for PostgreSQL provides automatic backups and point-in-time restore capabilities. These backups are taken automatically and retained for a set period (up to 35 days). You can also manually initiate backups. These backups include full backups, differential backups, and transaction log backups. Purging, or cleaning up old data, is not handled automatically by Azure Database for PostgreSQL. You would typically implement a custom script or process to delete or archive old data. This could be done through SQL scripts or by using external tools to manage data retention policies. Check the documentation ; https://learn.microsoft.com/en-us/azure/backup/backup-azure-database-postgresql