Hello
I know fly does a backup every 24hs of the database, I wanted to know if there is a way to export the database and how to implement it
Working with a ROR app
Hi… Yes, these are the “snapshots”. The recommended restore procedure is…
https://fly.io/docs/postgres/managing/backup-and-restore/#restoring-from-a-snapshot
You can stop short of the detach/attach part of the process if you just want to look at what the old data was like, etc.
For exporting to another storage location (e.g., to have a backup on your development laptop/desktop), you can use pg_dump in conjunction with SFTP (or flyctl proxy). That combination doesn’t have a nice step-by-step writeup anywhere, though, as far as I know…
Hope this helps a little!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.