How to back Postgres Flex Server data using Azure Backup

Question

Hello,

I was trying out "Azure Database for PostgreSQL Flexible server", but I am confused when it comes how the offering should work.
I created a vault and a backup instance for my Postgres server. Then I did an actual backup.

So far so good, but my confusion lies with "restore".
When I try restore the wizard asks me to provide storage account and a container and when I do all that I can see that restore process has save several SQL files which contain schema definitions for all database and role related scripts.

When I investigated those files I found out that there's no data? What is use of restore if I am going to end up with empty database?

Could somebody shine some light here and help me out if I am doing something wrong as all I did was follow this article https://learn.microsoft.com/en-us/azure/backup/backup-azure-database-postgresql-flex

Thanks,

Mirza

Answer 1

Hi 93316825 •,

Welcome to Microsoft Q&A forum.

As I understand, you are trying to restore Azure Database for PostgreSQL Flexible Server and could not find data.

1. Before you restore from Azure Database for PostgreSQL Flexible server backups, ensure that you have the required permissions for the restore operation.
2. Backup data is stored in the Backup vault as a blob within the Microsoft tenant. During a restore operation, the backup data is copied from one storage account to another across tenants. Ensure that the target storage account for the restore has the AllowCrossTenantReplication property set to true.

Reference: https://learn.microsoft.com/en-us/azure/backup/restore-azure-database-postgresql-flex

Let us know if above requirement meets in your case.

Awaiting your reply.

Thanks