title: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host
body: <p>I am trying to connect to PostgreSQL database which is in remote location using Spring JDBC template. I am getting </p>
  
  <blockquote>
    <p>org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "139.126.243.71", user "guest", database "masterdb", SSL off error</p>
  </blockquote>
  
  <p>I don't have access to pg_hba.conf file of the remote location. </p>
  
  <p>This is the configuration I gave in my spring servlet.xml</p>
  
  <pre class="lang-xml prettyprint-override"><code>&lt;bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"&gt;
      &lt;property name="driverClassName" value="org.postgresql.Driver"/&gt;
      &lt;property name="url" value="jdbc:postgresql://100.64.35.52":5432/masterdb"/&gt;
      &lt;property name="username" value="root"/&gt;
      &lt;property name="password" value="root"/&gt;
  &lt;/bean&gt;
  </code></pre>
  
  <p>Can we solve the issue by giving any properties?</p>