Hello,
for some raisons, i ignore, my postgres database don’t work since one month.
The status is suspended.
Can anyone help me please?
I don’t realy know the problem
Hello,
can someone help me?
Hi… What does fly m list -a db-app-name show?
Aside: there is a (probably unrelated) incident in progress with the Fly.io platform as a whole, so some commands might be a little flakey today…
Hi,
fly m list -a db-app-name show “No machines are available on this app app-name-db”
That typically indicates a hardware fault in the underlying physical host that your database Machine was running on. Usually, you can restore from the most recent volume snapshot:
https://community.fly.io/t/no-databases-in-postgres-after-restoring-from-a-snapshot/21432
https://fly.io/docs/postgres/managing/backup-and-restore/
I think the default retention period for snapshots in such cases is now a generous 60 days, 
, giving you ample time to catch up.
Hope this helps!
Added volumes
hello,
thanky you for you support.
you contributions help me a lot.
i restored the database from snapshot of the old database like mentioned her: Backup, Restores, & Snapshots · Fly Docs
But i was not able to detach the old database and attach the new database to the old app. I tried different article i found to the topic in internet, i got no success (due to acces key, etc…), therefore i decided to launch a new app without postgres-database and added the database_url of the restored postgres-db into the .env file. and after deployment allthing worked fine.
I hope my contrubition will help other persons
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.