PG database migration from Heroku not working

[tj1]

Try these instructions to download a dump and re-upload:

Transferring Postgres from Heroku

Wuhu it finally worked for me. Thank you so much @tj1 for leading me on the way. Here is a precise breakdown of what I did for it to work, with a lot of repetition from @tj1 's advice: Get your latest dump by running heroku login heroku pg:backups:capture heroku pg:backups:download In one terminal, launch: fly proxy 15432:5432 -a my-db-app-name # make sure it's the name of your db-app, not your main app In another terminal, list your db names to get the exact name of your DB with…