title: Heroku Postgresql pg:psql No Route to host
body: <p>For now I am just trying to make the <code>heroku pg:psql</code> command work but my final purpose is to copy a database that I have on my computer (localhost) to the heroku postgresql database with the <code>pg:push</code> command.</p>
  
  <p>For now when I simply try to access the database that I created on heroku, the <code>heroku pg:psql</code> command returns:</p>
  
  <pre><code>psql: could not connect to server: No route to host
      Is the server running on host "ec*-**-***-***-**.eu-west-1.compute.amazonaws.com" (**.***.***.**) and accepting
      TCP/IP connections on port 5432?
  </code></pre>
  
  <p>postgresql.conf: (the lines are not commented)</p>
  
  <pre><code>listen_address ='*'
  port = 5432
  ssl = true
  </code></pre>
  
  <p>and <code>host all all **.***.***.** trust</code> in <code>pg_hba.conf</code></p>
  
  <p>I also tried to add rules to iptables in order to give access to the database from the host IP address provided by heroku.</p>
  
  <p>I am on a Debian computer, how can I solve this?</p>