title: How can I get a plain text postgres database dump on heroku?
body: <p>Due to version incompatibilities of my postgres database on heroku (9.1) and my local installation (8.4) I need a plain text sql database dump file so I can put a copy of my production data on my local testing environment. </p>
  
  <p>It seems on heroku I can't make a dump using pg_dump but can instead only do this:</p>
  
  <pre><code>$ heroku pgbackups:capture
  $ curl -o my_dump_file.dump `heroku pgbackups:url`
  </code></pre>
  
  <p>...and this gives me the "custom database dump format" and not "plain text format" so I am not able to do this: </p>
  
  <pre><code>$ psql -d my_local_database -f my_dump_file.sql
  </code></pre>