🔧 Azure SQL Database & Migration Hands-On Lab | அசூர் எஸ் கியூ எல் டேட்டா பேஸ் Step-by-Step Guide 📊 

Thank you for your query! I understand your concern regarding the backup and deletion of your Azure PostgreSQL server. Let's address your doubts and provide a solution. Firstly, it's correct that Azure Database for PostgreSQL Flexible Server offers automated backups with a maximum retention period of 35 days, and these backups are deleted when the server is deleted. Now we have preview of long term retention using Azure backup vault Backup : learn.microsoft.com/en-us/azure/backup/backup-azure-database-postgresql-flex Restore : learn.microsoft.com/en-us/azure/backup/restore-azure-database-postgresql-flex Backup Configuration: Follow the steps outlined in the Azure Backup documentation to configure your backup for PostgreSQL Flexible Server. This allows you to schedule backups and take on-demand backups, which are stored in the Backup Vault. Restoring the Backup: When you restore a backup from Azure Backup Vault, it typically restores the database to a new or existing PostgreSQL server instance. Here's how to perform the restore To retain your data before deleting the server, you have a couple of options: Manual Backup Using pg_dump: You can create a manual backup of your PostgreSQL database using the pg_dump utility. This utility allows you to export your database to a SQL file, which you can then store safely. Here's a simple command to do this: pg_dump -h .postgres.database.azure.com -U -W -F c -b -v -f .sql Using Azure Backup Vault: As you mentioned, Azure Backup Vault can be used to schedule backups and take on-demand backups. These backups are stored as files in a storage account. To restore the backup, you can use the pg_restore utility. Here’s how you can use it: First, download the backup file from your storage account. Then, use the following command to restore the database: pg_restore -h .postgres.database.azure.com -U -W -d -v .sql

@@kmdfaizal Thank you so much Sir. I will try and let you know.