title: FATAL: no pg_hba.conf entry for host” but I can connect trough pgAdmin
body: <p><strong>Update</strong>: It seems to be problem with ElephantSQL, the service I'm using according to <a href="http://www.elephantsql.com/docs/dotnet.html" rel="nofollow noreferrer">this</a></p>
  
  <p>However, I dont know where to add this.</p>
  
  <p>Exact error:</p>
  
  <pre><code>FATAL: 28000: no pg_hba.conf entry for host "host", user "username", database "template1", SSL off
  </code></pre>
  
  <hr>
  
  <p>Similar error to this <a href="https://stackoverflow.com/questions/29738989/fatal-no-pg-hba-conf-entry-for-host-but-i-can-connect-trough-pgadmin">problem</a>. Even after adding <code>SslMode=require</code>, I still couldn't connect to the database.</p>
  
  <pre><code>&lt;add name="DefaultConnection" connectionString="Server=serverip;Port=5432;Database=dbname;User Id=username;Password=pass;CommandTimeout=60;Preload Reader=True;"/&gt;
  </code></pre>
  
  <p><strong>Weird thing is that it tried to connect to <code>template1</code> instead of database specified in the connection string.</strong></p>
  
  <p>Connecting through pgadmin is fine though.</p>