Install RPostgreSQL on RHEL 6.5 libpq-fe.h Error

r postgresql rpostgresql
Serban Tanasa picture Serban Tanasa · Oct 10, 2014 · Viewed 15k times · Source

I have RHEL 6.5 Server with an installation of R (3.1.1) & RStudioServer (0.98.1062)

I have postgresql-9.3 installed and handling a large database. In order to connect R to PostgreSQL, I have in the past used the RPostgreSQL (still do on my CentOS 7 Workstation). However, attempting to compile under RHEL 6.5 I get an error

In file included from RS-PQescape.c:7:
RS-PostgreSQL.h:23:26: error: libpq-fe.h: No such file or directory

The file is located on my system here:

/usr/pgsql-9.3/include/libpq-fe.h

Libpq is part of the Postgres installation, but RPostgreSQL cannot find it:

[root@server /]# yum list libpq*
Loaded plugins: product-id, refresh-packagekit, security, subscription-manager
Installed Packages
libpqxx.x86_64     1:4.0.1-1.rhel6                                               @pgdg93
libpqxx-debuginfo.x86_64     1:4.0.1-1.rhel6                                     @pgdg93
libpqxx-devel.x86_64   1:4.0.1-1.rhel6                                           @pgdg93

Is there any way to tell RPostgreSQL where to look (symbolic links?) or some other workaround? This should be simple, but I've wasted several hours on this already...

Answer

Curlew picture Curlew · Nov 27, 2014

Followup info because I just had the same problem.
Installing yum install postgresql-devel resolves the error too.

Related questions

How to use column defaults with dbWriteTable(..., append=TRUE) in RPostgreSQL

The dbWriteTable function in RPostgreSQL seems to ignore column names and tries to push data from R to PostgreSQL as-is. This is problematic when appending to existing tables, particularly if there are columns un-specified in the R object that should …

Read More
Using sqldf and RPostgreSQL together

When using RPostgreSQL I find that I cannot use sqldf in the same way. For example if I load the library and read in data into a data frame using the following code: library(RPostgreSQL) drv <- dbDriver("PostgreSQL") …

Read More
UTF-8 / Unicode Text Encoding with RPostgreSQL

I'm running R on a Windows machine which is directly linked to a PostgreSQL database. I'm not using RODBC. My database is encoded in UTF-8 as confirmed by the following R command: dbGetQuery(con, "SHOW CLIENT_ENCODING") # client_encoding # 1 UTF8 …

Read More