title: SSL connection to Redshift using Psycopg2
body: <p>I am trying to connect to a AWS Redshift server via SSL. I am using psycopg2 library in python to establish the connection and used <code>sslmode='require'</code> as a parameter in the connect line. Unfortunately i got this error:</p>
  
  <pre><code>sslmode value "require" invalid when SSL support is not compiled in
  </code></pre>
  
  <p>I read many other similar cases for PostgreSQL which mention the problem exists with the PostgeSQL version, but i didn't find any solutions for Redshift using Psycopg2. Do i need to install any specific SSL certificate for Redshift? If yes, how do i do it with Psycopg2? Any help will be appreciated.</p>