title: How to specify which postgres copy for rails to use
body: <p>How do I specify which version of postgres rails use? When I run <code>puma</code> and go to <code>localhost:3000</code> I get a an error</p>
  
  <pre><code>PG::ConnectionBad
  fe_sendauth: no password supplied
  </code></pre>
  
  <p>I think the copy being used may be the manual install 9.3, as when I run:</p>
  
  <pre><code>/usr/local/Cellar/postgresql/9.4.1/bin/pg_ctl -D /usr/local/var/postgres start
  </code></pre>
  
  <p>I get the error: </p>
  
  <pre><code>stgres start
  server starting
  LOG:  skipping missing configuration file "/usr/local/var/postgres/postgresql.auto.conf"
  FATAL:  database files are incompatible with server
  DETAIL:  The data directory was initialized by PostgreSQL version 9.3, which is not compatible with this version 9.4.1.
  </code></pre>
  
  <p>I found three copies of <code>pg_hba.conf</code> on my system:</p>
  
  <pre><code>/Library/PostgreSQL/9.3/data/pg_hba.conf
  /Users/lasernite/Library/Application Support/Postgres/var-9.4/pg_hba.conf
  /usr/local/var/postgres/pg_hba.conf
  </code></pre>
  
  <p>The first one I believe was from a manual install at some point. The second one is probably just some supporting copy/ignorable, and the third one is a homebrew install.</p>
  
  <p><strong>How can I make rails use the homebrew postgres install, even if it means wiping the local database?</strong> Which is fine so long as the production on heroku is instact.</p>
  
  <p>I've been stuck for several days on reconfiguring my development environment from sqlite to postgres, which is very problematic as I have a production db and site live now, which is forcing me to do some code pushes without being able to verify functionality locally, but for the most part has totally crippled my ability to do any development.</p>
  
  <p>Please help me!</p>