0

So heroku decided to delete hobby app databases as of Nov 28 and it wiped me out. I have a backup saved as '55e8c25e-2de7-4497-be94-6651363ca9e7', but have no idea how to access the data to hand-jam it into an excel spreadsheet to use in the interim. I used to use pgadmin, but it requires a direct link to a live database which heroku has since deleted. Is there a way for me to load this backup into a tool that would let me access the data?

Heroku has a message to open a ticket for situations like mine, but they don't let you open a ticket for hobby apps (go figure).

mjswartz
  • 715
  • 1
  • 6
  • 19
  • 2
    They sent like six emails about the pending shutdown. (I got them, too.) https://stackoverflow.com/questions/22887524/how-can-i-get-a-plain-text-postgres-database-dump-on-heroku seems to indicate `pg_restore` can be used on these files, but if not, fire up a paid Heroku database, import it, connect and download it, and then turn it back off. Total cost to you will be pennies. – ceejayoz Dec 08 '22 at 01:56

0 Answers0