Purging and Backup in Microsoft Azure

Shanmugaprabhu S 0 Reputation points
2024-01-23T03:11:01.9033333+00:00

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?

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,097 questions
Azure Database for PostgreSQL
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Amira Bedhiafi 12,161 Reputation points
    2024-01-23T10:55:08.8766667+00:00

    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

    0 comments No comments