title: Can't create dbConnect to Postgres with SSL
body: <p>I'm running a Postgres-9.4 server that I would like to require SSL for.  When I connect to the Postgres server from my laptop with either pgadmin or windows odbc connection, it works with SSL.  However when I try to connect with R using SSL it fails.</p>
  
  <pre><code>library(RPostgreSQL)
  drv &lt;- dbDriver("PostgreSQL")
  con &lt;- dbConnect(drv, 
                   user = "postgres", 
                   password = mypasswd, 
                   dbname = "dbname=postgres sslmode=prefer",
                   host = "192.168.1.179")
  </code></pre>
  
  <p>If I set my pg_hba.conf to allow non-ssl connections then this will work.  When I set it to only allow SSL connections then this will fail.  Unfortunately <code>dbConnect</code> doesn't have a <code>verbose</code> option so I don't get anything more than <code>could not connect postgres@192.168.1.179 on dbname "postgres"</code></p>
  
  <p>I found <a href="https://stackoverflow.com/questions/30989264/connect-to-postgres-via-ssl-using-r">this question</a> which seems to suggest I'm doing the right thing but, no go.</p>
  
  <p>Edit:</p>
  
  <p>I did some more digging and found <a href="https://groups.google.com/forum/#!topic/rpostgresql-dev/ELnVUJqjDbk" rel="noreferrer">this discussion</a> which suggests that this won't work on windows due to various library/dll issues.  That discussion is a few years old at this point so perhaps it has been resolved.  I can confirm that doing the above from linux does work.</p>