Geek Answers Handbook

Postgres SSLMode value "requires" Invalid when SSL support is not compiled using an external data fairing

I'm trying to connect to a remote server using an external data wrapper to transfer some data between databases, but keey gets an SSLMode value, which requires "Not valid when SSL support is not compiled." These are the fragments that I execute:

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;

DETAIL: sslmode value "requires" is not valid when SSL support is not compiled into

psql "sslmode=require" - , , . sslmode . postgres, , Heroku. , , . SSL ?

0
1

PostgreSQL libpq .

--with-openssl ( ./configure script postgres), openssl .

, , , libpq - SSL, , , SSL.

.

- libpq , SSL, , OpenSSL. , . , PostgreSQL SSL- .

libpq , . : , libpq , PostgreSQL

+2

More articles:


All Articles