有没有比Her Tap更快的从Heroku中提取生产数据的方法？

heroku pgbackups:capture

heroku pgbackups:url b001 (or whatever the id number of the backup is)

pg_restore --verbose --clean --no-acl --no-owner -h localhost -U test_user -d myapp_development /home/mike/Downloads/b001.dump

#!/bin/bash

# Best use case is to create a file \"update_local_db.sh\" in your project folder and then     
# call the command with bash update_local_db

# Follow me: @jackkinsella

function LastBackupName () { 
  heroku pgbackups | tail -n 1 | cut -d\"|\" -f 1
}

# This part assumes you have a low limit on no. of backups allowed
old_backup=$(LastBackupName)
heroku pgbackups:destroy $old_backup 

heroku pgbackups:capture 
new_backup=$(LastBackupName)
curl $(heroku pgbackups:url $new_backup) > temporary_backup.dump
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U REPLACE_WITH_YOUR_USER -d REPLACE_WITH_YOUR_DB_NAME temporary_backup.dump 
rm -f temporary_backup.dump

#!/bin/bash

# Run the following command: bash update_local_db.sh

# Getting computer name, which is the same as username in Postgres db
echo \"Please enter name of Computer\"
read input_variable
echo \"You entered: $input_variable\"

# Make a backup on Heroku
heroku pgbackups:capture --app APP_NAME
echo \"== Created a new backup ==\"

# Download the backup and name it latest.dump
curl -o latest.dump `heroku pgbackups:url --app APP_NAME`
echo \"== Downloaded the backup ==\"

# Restore local db with latest.dump
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U $input_variable -d my_db_name latest.dump
echo \"== Replaced db with downloaded ==\"

# Delete downloaded db latest.dump
rm -f latest.dump
echo \"== Deleted downloaded db ==\"
echo \"== Done! :) ==\"

#!/bin/bash

export MAIN_DB=NAME_OF_LOCAL_DB
export TMP_DB=NAME_OF_TEMPORARY_DB

function delete_db () {
    psql -d ${1} -c \"SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = \'$1\'
  AND pid <> pg_backend_pid();\" || true

    dropdb ${1} || true
}

delete_db ${TMP_DB}

heroku pg:pull DATABASE_URL ${TMP_DB} || exit 1

delete_db ${MAIN_DB}

psql -c \"ALTER DATABASE $TMP_DB RENAME TO $MAIN_DB;\"