search

greenplum-db / PivotalR-archive

An convenient R tool for manipulating tables in PostgreSQL type databases and a wrapper of Apache MADlib.
https://pivotalsoftware.github.io/gp-r/
125 stars 53 forks source link

How do I set the db.connect to use SSL? #57

Closed pottegil closed 4 years ago

pottegil commented 4 years ago

When I try to do a db.connect (host = host, etc. etc.) I am getting an error that the pg_hba.conf has no entry for my connection with SSL = off. Which is correct, we use SSL to connect to the database. However, i can't seem to find where one sets SSL = TRUE

pottegil commented 4 years ago

well answered my own question after some extensive searching: In the db.connect function, instead of dbname="name", it can carry the SSL Mode using the format, dbname="dbname=name sslmode=require"