Fails to compile in CentOS7 (fails to find existing libpq-fe.h)

[r-dbi]

Fails to compile in CentOS7 (fails to find existing libpq-fe.h)

[FlorianEndel]

In CentOS 5 I had to set these environment variables prior to compiling:

export LIBPQ_DIR=/usr/pgsql-9.3/
export LIBRARY_PATH=/usr/pgsql-9.3/lib

[esaostring]

Ok thanks. This seems to solve the compilation issue!

[krlmlr]

Closing for now, please feel free to reopen.

[dckc]

I'm using SLES 11, and I get the same symptoms.

I'm somewhat surprised that clues from pkg-config don't seem to be consulted.

> pkg-config libpq --cflags
-I/usr/include/pgsql 

I don't see how to reopen this issue. I'm not sure I understand the github issue workflow.

[krlmlr]

Thanks. I'll try to replicate this in CentOS. Which version will match SLES 11? (Or is there an easy way to run virtual or dockerized SLES 11?)

[dckc]

I hope to get the SLES details to you shortly...

Meanwhile, my solution was to put this in my ~/.R/Makevars:

PKG_CPPFLAGS=$(shell pkg-config libpq --cflags)
PKG_LIBS=$(shell pkg-config libpq --libs)

I expect you can use that to replace a lot of custom config stuff. I don't know if it'll work on OS X, but I'd expect it to work in just about all forms of linux.

[mmuurr]

Same issue on Amazon Linux.
PostgreSQL's header and library files are (by default) installed here:

/usr/include/pgsql/
/usr/lib64/pgsql/

... which are both just symlinks to the versioned installation directories.
I've patched my configure file in a fork, and am submitting a pull request now...

[krlmlr]

@dckc: Thanks for the hint on pkg-config. How portable/common is this? Would it be more robust to use pg_config?

@mmuurr: Would you mind implementing a more generic solution in #73?

[dckc]

pkg-config is everywhere, in my experience, though perhaps pg_config is to be found wherever the postgres headers are found

googlecounts:

• pkg-config: About 540,000 results
• pg_config: About 48,800 results

https://en.wikipedia.org/wiki/Pkg-config

[mmuurr]

I've updated the Amazon Linux solution to use pg_config when pkg-config fails (and it thus handles other Linux distros in the more general case).
Since it was a large change, I've closed #73 and would suggest referencing this thread against #81.

[krlmlr]

Closing, because #81 is merged now. (Thanks @mmuurr!) Please open a new issue if problems persist.

[cchris26]

I could solve the problem in my CentOS 7 only by setting the folder of pg_config in PATH.
export PATH=$PATH:/usr/pgsql-9.6/bin

[github-actions]

This old thread has been automatically locked. If you think you have found something related to this, please open a new issue and link to this old issue if necessary.