By ashconnor
I spun up a Postgres managed database which auto-created a backup. I noticed that this backup didn’t have any export options only restore.
Is it possible to back this up to another cloud provider?
I saw this provider can accomplish what I am asking but I was just wondering whether this is via some API or they are connecting to the DB over the internet and backup up that way.
https://www.digitalocean.com/community/tools/simplebackups-digitalocean-server-database-backups
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Accepted Answer
@ashconnor Good question.
Unfortunately, you cannot export managed database backups via the control panel or API. So all automated solutions for backing up your managed database to a different cloud will require a connection to the DB over the internet.
Despite that limitation, I think you could run a scheduled job from a DigitalOcean Droplet that does something like this at a set interval:
pg_dump
These instructions for exporting a postgresql database apply equally well for our postgres db’s.
Security considerations:
Cost-savings considerations:
pg_dump
has a --compress
or -Z
argument that will gzip the file, (or you could just compress it after pg_dump
.) Either way that will probably help you save your bandwidth budget and storage costs wherever you send the file.Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.