Hacker News new | ask | show | jobs
by samwillis 1614 days ago
To the Fly.io team here, other than the "daily storage-based snapshots of each of your provisioned volumes"[0], is there a plan to offer something similar to Heroku WAL based restore system [1] where you can (from the control panel) restore a db to a moment in time?

Also do you have any plans for a managed upgrading/patching of Postgres, again similar to Heroku?

For me personally the fully managed nature of Postgress on Heroku is brilliant and what I would love to see on Fly.io. It seems that on Fly its a little more hands on or am I missing something?

0: https://fly.io/docs/getting-started/multi-region-databases/#...

1: https://devcenter.heroku.com/articles/heroku-postgres-data-s...

1 comments

It's definitely more hands on.

We will be able to do a WAL backup / point in time restore feature when we ship object storage.

Managed upgrades are almost in. If you run `fly image show` it'll tell you if you need one, then `fly image update` will upgrade your Postgres. We don't do this automatically yet. It won't be difficult though.

> We will be able to do a WAL backup / point in time restore feature when we ship object storage

Brilliant! I have only had to use it once on Heroku, but that one time has me convinced that I couldn't live without it.