How to convert a Heroku Postgres dump to plain text
Sometimes you need to search within backups but don't want to restore the dump to a real database.
Backup files produced by Heroku Postgres are compressed. So they need to be converted to plain text.
- Download a backup file and name it e.g.
input.dumpto plain text using