configuring psqlodbc-13.00.0000 in RHEL7 64bit

Posted by satish on May 03, 2021; 9:10am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/configuring-psqlodbc-13-00-0000-in-RHEL7-64bit-tp9709.html

Dear Erman,

Our db version 12.1.0.2

OS version RHEL 7

we are trying to create dblink from oracle to postgresql database.As part of requirement,we are configuring psqlodbc driver.

I downloaded psqlodbc-13.00.0000.tar.gz and did following

% tar -zxvf psqlodbc-13.00.0000.tar.gz
% cd psqlodbc-13.00.0000
% ./configure
I am getting
"configure: error: libpq library version >= 9.2 is required
"
How can I resolve it?

But looks like it is existing:

[root@erpsupportdb psqlodbc-09.06.0500]# cd /usr
[root@erpsupportdb usr]# ls -lrt
total 328
drwxr-xr-x.   2 root root     6 Mar 10  2016 games
drwxr-xr-x.   2 root root     6 Mar 10  2016 etc
drwxr-xr-x.  12 root root   131 Mar 10  2017 local
lrwxrwxrwx.   1 root root    10 Mar 10  2017 tmp -> ../var/tmp
drwxr-xr-x.   4 root root    34 Mar 10  2017 src
drwxr-xr-x.  41 root root  8192 Mar 10  2017 libexec
drwxr-xr-x. 272 root root  8192 Apr  5  2017 share
drwxr-xr-x.   3 root root    17 Apr  5  2017 X11R6
dr-xr-xr-x.  54 root root 12288 Apr  5  2017 lib
dr-xr-xr-x.   2 root root 20480 Jan  7  2020 sbin
dr-xr-xr-x.   2 root root 61440 May  1 17:50 bin
drwxr-xr-x.  42 root root  8192 May  1 17:50 include
drwxr-xr-x    4 root root    30 May  3 14:09 pgsql-13
dr-xr-xr-x. 154 root root 98304 May  3 14:14 lib64

[root@erpsupportdb usr]# cd pgsql-13
[root@erpsupportdb pgsql-13]# pwd
/usr/pgsql-13
[root@erpsupportdb pgsql-13]# ls
lib  share

[root@erpsupportdb pgsql-13]# cd lib
[root@erpsupportdb lib]# ls -lrt
total 1120
-rw-r--r-- 1 root root 562754 Sep 23  2020 libpgfeutils.a
-rwxr-xr-x 1 root root  24416 Sep 23  2020 libpqwalreceiver.so
-rwxr-xr-x 1 root root 329632 Sep 23  2020 libpq.so.5.13
-rwxr-xr-x 1 root root  82608 Sep 23  2020 libpgtypes.so.3.13
-rwxr-xr-x 1 root root  96016 Sep 23  2020 libecpg.so.6.13
-rwxr-xr-x 1 root root  37176 Sep 23  2020 libecpg_compat.so.3.13
lrwxrwxrwx 1 root root     15 May  3 14:09 libecpg.so -> libecpg.so.6.13
lrwxrwxrwx 1 root root     15 May  3 14:09 libecpg.so.6 -> libecpg.so.6.13
lrwxrwxrwx 1 root root     22 May  3 14:09 libecpg_compat.so.3 -> libecpg_compat.so.3.13
lrwxrwxrwx 1 root root     18 May  3 14:09 libpgtypes.so.3 -> libpgtypes.so.3.13
lrwxrwxrwx 1 root root     13 May  3 14:09 libpq.so.5 -> libpq.so.5.13
[root@erpsupportdb lib]#

Any help?

Thank You