title: asyncpg error: "no pg_hba.conf entry for host" in Heroku
body: <p>I'm using asyncpg to connect my database in Heroku postgresql, using python:</p>
  
  <pre><code>import asyncpg
  
  async def create_db_pool():
     bot.pg_con = await asyncpg.create_pool(dsn="postgres://....", host="....amazonaws.com", user="xxx", database="yyy", port="5432", password="12345")
  </code></pre>
  
  <p>it was working perfectly until I received an email from heroku advising me of a maintenance: <br/> <code>Maintenance (DATABASE_URL on myappname) is starting now. We will update you when it has completed.</code></p>
  
  <p>then this error appeared:</p>
  
  <pre><code>asyncpg.exceptions.InvalidAuthorizationSpecificationError: no pg_hba.conf entry for host "123.456.789.10", user "xxx", database "yyy", SSL off
  </code></pre>
  
  <p>I tried to follow some help, like putting <code>ssl=True</code>
  but this error appeared:</p>
  
  <pre><code>ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate (_ssl.c:1108)
  </code></pre>
  
  <p>same as putting <code>ssl="allow"</code></p>
  
  <pre><code>asyncpg.exceptions.InvalidPasswordError: password authentication failed for user "xxx"
  </code></pre>
  
  <p>what can I do to fix this?</p>