heroku pg:pull --app myappname

pull from REMOTE_SOURCE_DATABASE to LOCAL_TARGET_DATABASE
LOCAL_TARGET_DATABASE must not already exist.

env DATABASE_URL=postgres://localhost/alwaysthesameappname heroku pg:transfer --app alwaysthesameappname

env: pg_restore: No such file or directory
env: pg_dump: No such file or directory

/Library/PostgreSQL/9.2/bin/