Dean Christian Armada
Dean Christian Armada

Reputation: 7364

Microsoft Azure backup VM database every hour

I would like to have some help regarding this.. What I want to achieve is for my PostgreSQL installed on my docker-container in a VM to be backed-up every hour and that backup will be deleted for 2 hours.

Upvotes: 0

Views: 924

Answers (1)

Fei Han
Fei Han

Reputation: 27793

I read about the microsoft blobs, and I think that's what I'm looking for but the question for now is.. How to transfer the backup of Postgresql database to the microsoft blob.. Is there a shell command for that?

I find this PostgreSQL-Backup tool provides a way to backup PostgreSQL, and it seems support backup PostgreSQL to Azure Storage, but this feature is not free.

Besides, even if you backup PostgreSQL to Azure Blob, currently Azure Blob storage does not provide auto-delete feature. You could try to mount the file share and use the basic feature (not be charged) that PostgreSQL-Backup tool provides to backup PostgreSQL to that file share, and then you could run a WebJob to detect backup files and dynamically&programmatically delete backup files.

Upvotes: 1

Related Questions