当通过R Postgres连接到RDS时，如何指定证书？

Question

    #https://cran.r-project.org/web/packages/RPostgres/README.html

    library(DBI)
    # Connect to a specific postgres database i.e. Heroku
    con <- dbConnect(RPostgres::Postgres(),dbname = 'DATABASE_NAME', 
                     host = 'HOST', # i.e. 'ec2-54-83-201-96.compute-1.amazonaws.com'
                     port = 5432, # or any other port specified by your DBA
                     user = 'USERNAME',
                     password = 'PASSWORD')

尝试连接到数据库，但我收到ssl验证错误，因为远程数据库是Aurora。是否有传递SSL CA根目录的参数？

Answer 1

你可以这样做：

rt_cert <- paste0("PATH_OF_ROOT_CERTIFICATE/root-ca.crt")
cl_cert <- paste0("PATH_OF_ROOT_CERTIFICATE/xxx.crt")
cl_key <- paste0("PATH_OF_ROOT_CERTIFICATE/xxx.key")

con <- dbConnect(drv = RPostgres::Postgres(), 
                 dbname = 'DATABASE_NAME', 
                 host = 'HOST', # i.e. 'ec2-54-83-201-96.compute-1.amazonaws.com'
                 port = 5432, # or any other port specified by your DBA
                 user = 'USERNAME',
                 password = 'PASSWORD',
                 sslmode = 'require',
                 sslrootcert = rt_cert,
                 sslcert = cl_cert,
                 sslkey = cl_key)