Is postgres on Fly ready to host production databases ?

[shaun]

@adamwiggall I’m super sorry about that! I was balancing a couple conversations and looks like my wires crossed. Feel free to ignore my previous response…

So as you discovered, you can list the volumes with:

fly volumes list --app <app-name>

Then you can take the volume id and run the following to get a list of snapshots:

fly volumes snapshots list <volume-id>

Let me know what you see.

[adamwiggall]

Shaun,

Thank you very much my friend, I do now see the backups, that’s great.

I appreciate you coming back to me!

Adam

[nickluger]

Maybe relevant for this topic, as @moissela already asked this a while ago.

PostgreSQL database backup & restore

How is the status regarding PostgreSQL db backup & restore. Is there something planned/some ETA for this? Many managed database services out there offer some kind of PITR besides automatic snapshots. I discovered volume snapshots but they have a an RPO of 24 hours? Also: Read-replicas don’t protect against human error or malicious events (DROP TABLE), as they propagate instantly. (Although having a delayed replication would work)… We could set up all this ourselves using something like WAL-G…

Just a short comment whether we should roll our own strategy or wait for something Fly is working on would be most helpful. Thanks in advance!

[sheharyar]

Bump! Is there an update on Database backups?

[jasonfine]

I am also curious about this, i am currently evaluating Fly and am wondering about strategies for PITR with Fly’s Postgres clusters.