title: database.yml file configuration and postgres - rake db:drop db:create db:migrate
body: <p>I recently switched to postgres for a rails app in development since I deployed on Heroku and want to match production.  Postgres is installed and working correctly for my application when I set the database name equal to 'postgres', which is the default name from what I understand.</p>
  
  <p>However, I would like to change the database name for development, test and production.  If I simply change the names in database.yml, and try to run a rake task, I get the following error in my terminal:</p>
  
  <pre><code>NOTICE:  database "something_development" does not exist, skipping
  Couldn't drop something_test : #&lt;PG::Error: could not connect to server: No such file or directory
  Is the server running locally and accepting
  connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?&gt;
  rake aborted!
  FATAL:  database "something_development" does not exist
  </code></pre>
  
  <p>Here is what my database.yml file currently looks:</p>
  
  <pre><code>development:
    adapter: postgresql
    host: localhost
    database: something_development
  
    username: name
  
  
  test:
    adapter: postgresql
    database: something_test
    pool: 5
    timeout: 5000
  
  production:
    adapter: postgresql
    host: localhost
    username: name
    database: something_production
  </code></pre>
  
  <p>Are there some other steps I am missing?  Apologies if I am missing something obvious here!  Thanks!</p>