Automate PostgreSQL database backup directly to your Microsoft Azure Blob Storage.
With SimpleBackups, you can backup PostgreSQL database to any cloud storage provider.
In this article, I'll go through the entire process of setting up your backup and store it on Microsoft Azure Blob Storage specifically.
Select "Azure Blob Storage" in the storage providers list and fill in the "Connect your storage" form with your Microsoft Azure credentials and newly created container information
You'll have to input :
Account Name: Account Name described in (step 2)
Access Key: Secret Key described in (step 2)
Container: Container name described in (step 1)
Ending Suffix: your storage endpoint described in (step 1)
Give your storage a name (usually we like to use the storage name) and click on "Save new storage".
You'll be redirected to the list of storage where you'll find your newly connected storage.
Select "Database" (in this article we're creating a PostgreSQL backup only)
Select the server on which your database is hosted (if haven't yet configured any server check our "get your server configured" article first)
How often should we make this backup? (B)
Select your schedule option (here we picked a daily schedule)
You can select a pre-defined schedule (daily, weekly, monthly) or a custom option allowing you to schedule it whenever you want using CRON syntax.
Example of CRON schedule for "20:00 every Tuesday" = 0 22 * * 2
Finally the "On demand" option won't schedule anything but will allow you to trigger the backup manually or using our API.
Define the backup retention, which is the number of backups you want to keep (kind of the history length of your backup if you prefer)
Choose the database you need to backup (C)
Select the type of your database, in this case "PostgreSQL"
Fill in the database connection form.
Note: In order to backup all databases of your server at once, you'd need a Standard or upper plan
Finalize and create
Pick the name of your backup (this is how it will be displayed in SimpleBackups interface) and where you want to store it.
Select your storage (step 3)
That's it, your PostgreSQL backup is now ready.
Run it once manually (using the "Run" backup button from the backups list) and you'll trigger your first backup!
Ready to automate your backups?
Sign up for FREE. Get started in less than one minute.