libpq-fe.h finally found, then PQfmod symbol undefined #140
Description
At my wits end trying to install this package on RHEL 8.
dependency postgresql-devel depends on perl-IPC-Run depends on perl-IO-Pty depends on rhel special repo powertools (which isn't even available)
Finally I get every single unbelievably difficult to locate repo installed only to have to manually move the libpq-fe.h file, then still ending up with a final error that RPostgreSQL couldn't be loaded: PQfmod undefined symbol
* installing *source* package ‘RPostgreSQL’ ...
** package ‘RPostgreSQL’ successfully unpacked and MD5 sums checked
** using staged installation
checking build system type... x86_64-pc-linux-gnu
checking host system type... x86_64-pc-linux-gnu
checking target system type... x86_64-pc-linux-gnu
checking for pg_config... no
configure: checking for PostgreSQL header files
configure: Checking include /usr/include.
configure: Checking lib /usr/lib.
configure: Checking lib /usr/lib/postgresql.
configure: Checking lib /usr/local/lib.
configure: Checking lib /usr/local/lib/postgresql.
configure: Checking lib /usr/local/postgresql/lib.
-I/usr/include -L conftest.c -lpq -o pqconftest
./configure: line 1997: -I/usr/include: No such file or directory
./pqconftest
./configure: line 1999: ./pqconftest: No such file or directory
system -lpq don't appear to work; use internal
checking for "/usr/include/libpq-fe.h"... yes
configure: creating ./config.status
config.status: creating src/Makevars
** libs
gcc -I"/opt/R/3.6.3/lib/R/include" -DNDEBUG -I/usr/include -I/usr/local/include -fpic -g -O2 -c RS-DBI.c -o RS-DBI.o
gcc -I"/opt/R/3.6.3/lib/R/include" -DNDEBUG -I/usr/include -I/usr/local/include -fpic -g -O2 -c RS-PQescape.c -o RS-PQescape.o
gcc -I"/opt/R/3.6.3/lib/R/include" -DNDEBUG -I/usr/include -I/usr/local/include -fpic -g -O2 -c RS-PostgreSQL.c -o RS-PostgreSQL.o
gcc -I"/opt/R/3.6.3/lib/R/include" -DNDEBUG -I/usr/include -I/usr/local/include -fpic -g -O2 -c RS-pgsql-copy.c -o RS-pgsql-copy.o
gcc -I"/opt/R/3.6.3/lib/R/include" -DNDEBUG -I/usr/include -I/usr/local/include -fpic -g -O2 -c RS-pgsql-getResult.c -o RS-pgsql-getResult.o
gcc -I"/opt/R/3.6.3/lib/R/include" -DNDEBUG -I/usr/include -I/usr/local/include -fpic -g -O2 -c RS-pgsql-pqexec.c -o RS-pgsql-pqexec.o
gcc -I"/opt/R/3.6.3/lib/R/include" -DNDEBUG -I/usr/include -I/usr/local/include -fpic -g -O2 -c RS-pgsql-pqexecparams.c -o RS-pgsql-pqexecparams.o
gcc -shared -L/opt/R/3.6.3/lib/R/lib -L/usr/local/lib -o RPostgreSQL.so RS-DBI.o RS-PQescape.o RS-PostgreSQL.o RS-pgsql-copy.o RS-pgsql-getResult.o RS-pgsql-pqexec.o RS-pgsql-pqexecparams.o -L -lpq -L/opt/R/3.6.3/lib/R/lib -lR
installing to /opt/R/3.6.3/lib/R/library/00LOCK-RPostgreSQL/00new/RPostgreSQL/libs
** R
** inst
** byte-compile and prepare package for lazy loading
** help
*** installing help indices
converting help for package ‘RPostgreSQL’
finding HTML links ... done
Error: package or namespace load failed for ‘RPostgreSQL’ in dyn.load(file, DLLpath = DLLpath, ...):
unable to load shared object '/opt/R/3.6.3/lib/R/library/00LOCK-RPostgreSQL/00new/RPostgreSQL/libs/RPostgreSQL.so':
/opt/R/3.6.3/lib/R/library/00LOCK-RPostgreSQL/00new/RPostgreSQL/libs/RPostgreSQL.so: undefined symbol: PQfmod
Error: loading failed
Execution halted
ERROR: loading failed
* removing ‘/opt/R/3.6.3/lib/R/library/RPostgreSQL’
The downloaded source packages are in
‘/home/vhapalgeise0/tmp/Rtmpy6M4MO/downloaded_packages’
Updating HTML index of packages in '.Library'
Making 'packages.html' ... done
Warning message:
In install.packages("RPostgreSQL") :
installation of package ‘RPostgreSQL’ had non-zero exit status