Hm… A couple of other people were hit by this in Singapore recently as well, :
https://community.fly.io/t/fly-singapore-database-randomly-died/22835
Restoring from a snapshot is the surest bet, but in principle there might be some possibility of detaching the existing volume and assigning it to a fresh Machine. What kind of application is this?