SSL mode with RPostgreSQL driver

[roimartins]

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]

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]

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]

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]

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]

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.