pg_quick_recover
Ran into an issue where I needed to access a Postgres backup today. To my dismay I realized it was compressed and could only be accessed by importing it into a Postgres database. After fumbleing around for about 20 minutes setting one up, I decided I never wanted to do it again.
TL;DR
Put this in your PATH
and use it (pg_quick_recover backup.sql.db
) to quickly spin