windows - Rstudio 无法连接到 Windows 机器上启用 SSL 的 postgresql 服务器

Question

我在从 Windows 连接启用 SSL 的 PostgreSQL 服务器时遇到问题。我收到以下错误:

Error :
Error in postgresqlNewConnection(drv, …) :
RS-DBI driver: (could not connect ip:80 on dbname "all": sslmode value "require" invalid when SSL support is not compiled in.

我用过的命令:

install.packages(“RPostgreSQL”)
install.packages(“rstudioapi”)
require(“RPostgreSQL”)
require(“rstudioapi”)
drv <- dbDriver("PostgreSQL")
pg_dsn = paste0(
'dbname=', "all", ' ',
'sslmode=require')

con <- dbConnect(drv,
dbname = pg_dsn,
host = "ip",
port = 80,
user = "abcd",
password = rstudioapi::askForPassword("Database password"))

Answer 1

您需要使用支持 SSL 的 PostgreSQL 客户端共享库 (libpq.dll)。