RS-PostgreSQL.h:23:26: error: libpq-fe.h: No such file or directory

Error in installing RPostgreSQL

m=ssp-buffer-size=4 -m64 -mtune=generic  -c RS-PQescape.c -o RS-PQescape.o

In file included from RS-PQescape.c:7:

RS-PostgreSQL.h:23:26: error: libpq-fe.h: No such file or directory

RS-PQescape.c: In function ‘RS_PostgreSQL_escape’:

RS-PQescape.c:21: error: ‘PGconn’ undeclared (first use in this function)

RS-PQescape.c:21: error: (Each undeclared identifier is reported only once

RS-PQescape.c:21: error: for each function it appears in.)

RS-PQescape.c:21: error: ‘my_connection’ undeclared (first use in this function)

RS-PQescape.c:28: error: expected expression before ‘)’ token

RS-PQescape.c:32: warning: implicit declaration of function ‘PQescapeStringConn’

make: *** [RS-PQescape.o] Error 1

ERROR: compilation failed for package ‘RPostgreSQL’

* removing ‘/usr/lib64/R/library/RPostgreSQL’

The downloaded source packages are in

        ‘/tmp/RtmpKut82D/downloaded_packages’

Solution

yum install postgresql-devel