search

Cidree / rpostgis

rpostgis: R Interface to a 'PostGIS' Database
http://cidree.github.io/rpostgis/
77 stars 14 forks source link

SSL mode with RPostgreSQL driver #15

Closed roimartins closed 4 years ago

roimartins commented 5 years ago

I try to connect to a SSL PostgreSQL instance using RPostgreSQL , but apparently it isn't supported. It works fine when the library used is 'RPostgres' , however rpostgis only works with RPostgreSQL driver connections . 'RPostgres' library has better maintenance lately , would be useful allow connections from this library .

BernoGreyling commented 5 years ago

Having the exact same issues on windows. The package works fine on Ubuntu though as ssl can be configured there. Would also appreciate adding support for RPostgres.

dnbucklin commented 5 years ago

Thanks for letting us know about this. I've done minimal testing with RPostgres, but I've seen that there are differences in query handling and returned values using RPostgreSQL vs. RPostgres drivers, so that simply switching drivers in rpostgis calls currently causes errors for several of the functions (though some do work).

@roimartins Any chance that this solution could help with SSL connection?

basille commented 4 years ago

No activity for almost six months on this issue, I'm closing it — feel free to reopen if you want to add more information to the issue.

BernoGreyling commented 4 years ago

Hi, just want to confirm that SSL support for windows is not going to be added in the near future as @dnbucklin 's answer unfortunately does not solve the problem on Aiven hosted postgres.

basille commented 4 years ago

Support for the RPostgres driver has just been added in v1.4.3, as an experimental feature, which now allows for connection over SSL. Please upgrade and test for any issue — feedback greatly appreciated.

Mention in the changelog:

The RPostgres::Postgres() driver can now be used as a connection. While rpostgis is functional with the driver, it should be considered experimental and may not function as expected in all cases. The default RPostgreSQL::PostgreSQL() driver is recommended for most use cases.