title: Can't connect to Postgres using pgadmin
body: <p>I am trying to connect to my postgres database which is install on AWS EC2 instance. </p>
  
  <p>I have installed pgadmin3 on my local ubuntu machine and I am trying to connect my postgres but I am getting error:</p>
  
  <pre><code> reports could not connect to server: Connection refused Is the server running on host "myip" and accepting TCP/IP connections on port 5432? 
  </code></pre>
  
  <p>On aws I have open port 5432.</p>
  
  <p>I edited my postgresql.conf and I added :</p>
  
  <pre><code> listen_addresses = '*'
  </code></pre>
  
  <p>and inside pg_hba.conf I added this:</p>
  
  <pre><code>host    all         all         192.168.1.0/24        md5
  </code></pre>
  
  <p>But now I am getting this error:</p>
  
  <pre><code> FATAL: no pg_hba.conf entry for host "myip", user "postgres", database "postgres", SSL on FATAL: no pg_hba.conf entry for host "myip", user "postgres", database "postgres", SSL off getting this error
  </code></pre>