title: Can't connect to PostgreSQL database after pushing to Heroku
body: <p>I fear this may be a dumb question/easy fix, but have been stuck for a while. Would really appreciate any feedback you may have.</p>
  
  <p>Both my development and production databases are Postgres. After pushing to Heroku, I was having issues with my scss files in my development environment. (Updates to the SCSS files were not reflected in my DEVELOPMENT environment, despite having the default config. settings. Not sure if this is an expected result from precompiling for the production env.)</p>
  
  <p>After restarting my system, I can no longer connect to the Postgres database. I get the same error through the command line (rails s) and pgAdminIII, that says, "</p>
  
  <pre><code>could not connect to server: Connection refused (0x0000274D/10061) Is the
  server running on host "127.0.0.1" and accepting TCP/IP connections on port 
  5432?
  </code></pre>
  
  <p>My files are configured as below, and fit the descriptions given in the other posts I found related to this issue. Also, I am able to access localhost:3000 with my SQLite3 projects.
  Any feedback would be appreciated.</p>
  
  <p>My postgresql.conf file </p>
  
  <pre><code>#------------------------------------------------------------------------------
  # CONNECTIONS AND AUTHENTICATION
  #------------------------------------------------------------------------------
  # - Connection Settings -
  listen_addresses = '*'
  port = 5432
  max_connections = 100
  </code></pre>
  
  <p>My pg_hba.conf file</p>
  
  <pre><code># TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
  # IPv4 local connections:
  host    all         all         127.0.0.1/32          md5
  # IPv6 local connections:
  host    all         all         ::1/128               md5
  </code></pre>