title: fatal: no pg_hba.conf entry for host when trying to connect to a redshift database from a new Mac(Catalina)
body: <p>I recently got a new system where i have been setting up and installing R and RStudio using Homebrew. However, when i try to connect to my redshift database from RStudio I keep running into missing pg_hba.conf entry error. I tried locating this file and came across below:</p>
  <pre><code>(base) ➜  workspace locate pg_hba.conf
  /usr/local/Cellar/postgresql/13.2_1/share/postgresql/pg_hba.conf.sample
  /usr/local/share/postgresql/pg_hba.conf.sample
  </code></pre>
  <p>not sure if these are the right ones. I installed Rpostgres and RpostgreSQL from R and tried brew install for postgres. None of these seem to be solving the issue. I get the same error. And I tried setting SSL = &quot;require&quot; in the connection statement. But it wont let me manually turn on SSL. I believe its some file missing, or path missing but i have not come across any solutions so far which can help me figure out how to solve this.</p>