title: Postgres SSLMode Value "require" Invalid When SSL Support Is Not Compiled Using Foreign Data Wrapper
body: <p>I'm attempting to connect to a remote server using a foreign data wrapper to transfer some data between databases but keey getting 'SSLMode Value "require" Invalid When SSL Support Is Not Compiled In'. These are the snippets I'm running:</p>
  
  <pre><code>CREATE SERVER remote FOREIGN DATA WRAPPER postgres_fdw
  OPTIONS(dbname '...', host '...', port '...', sslmode 'require');
  
  CREATE USER MAPPING FOR USER SERVER remote
  OPTIONS (user '...', password '...');
  
  CREATE FOREIGN TABLE remote.accounts (
    ...
  );
  
  SELECT * FROM remote.accounts;
  </code></pre>
  
  <blockquote>
    <p>DETAIL:  sslmode value "require" invalid when SSL support is not compiled in</p>
  </blockquote>
  
  <p>I've tried connecting into <code>psql</code> using <code>"sslmode=require"</code> - but that doesn't seem to help. I've also included <code>sslmode</code> as a flag when creating the server. The postgres instance I'm connecting to is on Heroku. The queries run if I connect to a different database on a remote server - but fail from my local database. How can I fix the SSL support is not compiled in? </p>