Thursday, February 25, 2016

RPostgreSQL Data analytics on PostgreSQL data using R

RPostgreSQL - Data analytics on PostgreSQL data from R

Data analytics on PostgreSQL data using R. Working with R and PostgreSQL for large scale data analytics

Installing RPostgreSQL
install.packages('RPostgreSQL')

compilation terminated. /usr/lib/R/etc/Makeconf:128: recipe for target 'RS-PQescape.o' failed make: *** [RS-PQescape.o] Error 1 ERROR: compilation failed for package 'RPostgreSQL' * removing '/home/boss/R/x86_64-pc-linux-gnu-library/3.1/RPostgreSQL'
RS-PostgreSQL.h:23:26: fatal error: libpq-fe.h: No such file or directory

Solution

RPostgreSQL require libpq-dev.

libpq-dev is a set of library functions that allow client programs (for our case its 'R') to pass queries to the PostgreSQL backend server and to receive the results of these queries.


So we have to install libpg-dev on OS not from R terminal

solai@server# sudo apt-get install libghc-postgresql-libpq-dev

then install RPostgreSQL inside R session
> install.packages('RPostgreSQL')

3 comments:

JacobHarman said...

On the off chance that you're not a specialist in that frame of mind of IoT, it very well may be hard to tell what to search for when you enlist IoT programmers. Hence, it is urgent to advance in any event a portion of the terms utilized in the field, the abilities to pay special attention to and the kind of programming IoT designers use.

During the recruiting system, you need to know what you're talking about at the surface level. Along these lines, you will rouse certainty and confidence in the designer that they will be working for somebody who knows precisely exact thing they're doing>> look at here now

Essay Writing Services said...

Thanks for sharing amazing blog!

Anonymous said...

Thanks for consistently delivering thought-provoking content that enriches the online landscape. Navigating your blog is like entering a virtual arena for cps tester, where each click is a step towards enhanced digital prowess.