title: Rake db:reset 'user does not have CONNECT privilege'
body: <p>So I'm using Heroku Postgres in my Rails app, but I'm not hosting my app on Heroku itself. I used the Active Record connection details from Heroku in my database.yml, and it looks like this:</p>
  
  <pre><code>development:
  adapter: postgresql
  encoding: unicode
  pool: 5
  database: [database]
  username: [username]
  password: [password]
  host: ec2-54-227-243-78.compute-1.amazonaws.com
  port: 5432
  </code></pre>
  
  <p>However, now I'm trying to rake db:migrate my app so the database gets all set up with my models. Running that command doesn't do anything, so I tried <code>rake db:reset</code> and I get this:</p>
  
  <pre><code>Couldn't drop df2cokjfj0k4vu : #&lt;PG::Error: FATAL:  permission denied for database "postgres"                                                                  
  DETAIL:  User does not have CONNECT privilege.                                                                                                                 
  </code></pre>
  
  <blockquote>
    <p>df2cokjfj0k4vu already exists<br>
    -- initialize_schema_migrations_table()<br>
       -> 1.3997s<br>
    -- assume_migrated_upto_version(20130924040351, ["/home/action/braindb/db/migrate"])<br>
       -> 0.0882s              </p>
  </blockquote>
  
  <p>Any idea what I'm doing wrong. I'm still pretty new to Rails so sometimes I forget how to get my Postgres database setup properly when migrating hosts.      </p>