title: Install RPostgreSQL on RHEL 6.5 libpq-fe.h Error
body: <p>I have RHEL 6.5 Server with an installation of R (3.1.1) &amp; RStudioServer (0.98.1062)</p>
  
  <p>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</p>
  
  <pre><code>In file included from RS-PQescape.c:7:
  RS-PostgreSQL.h:23:26: error: libpq-fe.h: No such file or directory
  </code></pre>
  
  <p>The file is located on my system here:</p>
  
  <pre><code>/usr/pgsql-9.3/include/libpq-fe.h
  </code></pre>
  
  <p>Libpq is part of the Postgres installation, but RPostgreSQL cannot find it:</p>
  
  <pre><code>[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
  </code></pre>
  
  <p>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...</p>