Postgres Flexible server copy native backup to Storage Account

Evelyn Dibben 6 Reputation points
2022-11-10T18:52:29.107+00:00

pg_dump is not an option due to the projected size of the database.

It appears that the Azure backup only works for Postgres Single Server.

My requirement is to copy the native Postgres backups to storage accounts. These backups need to be made immutable and the retention must be greater than 35 days. Of course I would need a way to restore from these backups. Point in time would be nice but I would understand if that wasn't possible.

Is there a way to copy the backups to a storage account? If not can the native backups be marked as immutable?

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,192 questions
Azure Database for PostgreSQL
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
    2022-11-15T03:50:01.46+00:00

    Hi @Evelyn Dibben Thank you for your query.

    As per my understanding you are trying to make a copy of your Azure PostgreSQL DB backups to azure storage account.
    This can be done using Azure Files. see Backup Azure Database for PostgreSQL to a Blob Storage

    Please let us know if this helps.

    Regards,
    Oury


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.