I'd like to copy the Postgres database from a production environment to a test environment, but it doesn't seem that the Heroku CLI is available on the Heroku app server (heroku run bash, then try running heroku).
Ideally I could do this using Heroku Scheduler, but for now I'm running this command locally:
heroku pg:copy [myapp]-prod::postgresql-[stack]-[id] postgresql-[stack]-[id] --app [myapp]-test
Any thoughts or suggestions?