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
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
@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.