A Small Backup Restore Drill

Find out whether a PostgreSQL backup really restores by loading it into a throwaway database and checking the result.