Re:Fully managed PostgreSQL databases
by WrtCdEvrydy on Thursday February 14, 2019 @02:53PM
(#19165347)
Dokku is a management platform kinda like a self-hosted Heroku.
I've used it instead of Flynn in the past with a lot of success.
Edit: If S3 is the problem, backup to a minio instance on your dokku (https://github.com/slypix/minio-dokku)
Re:Fully managed PostgreSQL databases
by avolcano on Thursday February 14, 2019 @04:57PM
(#19166470)
I suppose I could also use DO's Spaces, which is S3-compatible, though also has an annoying minimum (I do not need the 250 gigs you get for $5/mo) https://www.digitalocean.com/products/spaces/
I think what I really want is managed backups that live outside of my box, and the ability quickly restore from one if my database crashes or becomes unusable. I think automated failover to another node may not be a reasonable ask for such a cheap product.
Of course, at that point: I could spin up a 1GB DigitalOcean volume for $0.10/mo, and set up scripts to run `pg_dump` every couple hours, clean the volume of older backups to free up space, and ideally a script to reset the database to a given volume. _That's all stuff I don't want to do_, but maybe someone's built a reusable set of scripts for it or something - that Dokku container is promising as a starting point, though I'm a little annoyed it only works with S3(-compatible).