search

Cidree / rpostgis

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

Update dbUtils_notExported.R #16

Closed roimartins closed 5 years ago

roimartins commented 5 years ago

accept connections from Rpostgres library. The Rpostgres library allows SSL connections to PostgreSQL instances , RPostgreSQL library doesnt.

https://www.rdocumentation.org/packages/RPostgres/versions/1.1.1

dnbucklin commented 5 years ago

Hi @roimartins , I think we had looked into this a while back and ran some limitations on functionality. Perhaps those have been addressed by now; if you'd like to test with RPostgres connections on your fork, that would be great. I'd suggest you work off of the dev branch, however.

Also you'll need to used conn, not con_raster as your connection object: inherits(conn, "PqConnection")

roimartins commented 5 years ago

Thanks , I have followed your suggestions and I have created a new branch and modified the 'conn' parameter and now it works fine for me . I have tried in some R Shiny projects and works smoothly loading the raster from PostGIS using RPostgres connection .