title: Copy database between Heroku environments using Heroku Scheduler
body: <p>I'd like to copy the Postgres database from a production environment to a test environment, but it doesn't seem that the <a href="https://devcenter.heroku.com/articles/heroku-command" rel="nofollow">Heroku CLI</a> is available on the Heroku app server (<code>heroku run bash</code>, then try running <code>heroku</code>).</p>
  
  <p>Ideally I could do this using <a href="https://devcenter.heroku.com/articles/scheduler" rel="nofollow">Heroku Scheduler</a>, but for now I'm running this command locally:
  <code>heroku pg:copy [myapp]-prod::postgresql-[stack]-[id] postgresql-[stack]-[id] --app [myapp]-test
  </code></p>
  
  <p>Any thoughts or suggestions?</p>