Capture a Heroku PostgreSQL backup, download it, and restore it to your local development database.

import.sh

#!/bin/sh

set -e

app=$1
local_db=${app}_development

# Create the backup on heroku
heroku pgbackups:capture --expire

# Download the backup
curl -# -o /tmp/${app}.dump `heroku pgbackups:url`

# Restore the backup
pg_restore --verbose --clean --no-acl --no-owner -h 127.0.0.1 -U `whoami` -d ${local_db} /tmp/${app}.dump

# Clean up
rm -f /tmp/${app}.dump

set +e

Thanks for sharing :)