Fly Postgres database issues

Several months ago my machines and my postgres cluster attached to my web app stopped working, this happened because the host had some hardware issues, but, now, this problem is gone and I have tried to restart my service and have not been successful. I would like to know how to do this or at least recover all my data and export it to a sql file or something like this.

Does anyone know how to do this?

Hi… Try this, to get an initial assessment:

$ fly m   list       -a db-app-name
$ fly vol list --all -a db-app-name

If you still have volumes left, then things can probably be recovered, :adhesive_bandage:; otherwise, “several months” may be too late—unfortunately…

(The snapshots age off, i.e., auto-delete, after a while.)

Added volumes

Hi, thank you for your answer,

I already did it and good news, I have both machines and volumes. Now, what will be the next steps to recover my data?

Glad to hear it… In that case, which exact commands have you already tried in the way of restart attempts, and what did you see in the logs while they ran?

Great news, I got all my data back!

I thought I had already tried the create --fork-from command, but I did not, and, after that, I was finally able to get my data back.

Thank you very much for your help and comments.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.