Postgres database stop suddenly (dead) in my Rails App

[angordeyev]

It is probably related to Postgres app fails on restart/deployment.

Are you able to connect to your DB application console?

fly ssh console -a <some-application-db>

You can try to retrieve your data then:

pg_dump mismatch

I assume some-application and some-application-db are deployed. Go to the some-application console: fly ssh console -a some-application Get the database name, login, and password: echo $DATABASE_URL It will show the string in the following format: postgres://some_login:some_password@some-address.internal:5432/some_db_name?sslmode=disable Go to the DB machine console: fly ssh console -a some-application-db Make a dump: pg_dump --username=some_login --dbname=some_db_name --port=5432 --ho…

You can try snapshots if it works for you.