Posted by
satish on
May 03, 2021; 4:57am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/DBlink-from-oracle-to-postgresql-DG4ODBC-tp9698.html
Dear Erman,
This link is really helpful,ofcourse i am creating to postgress instead of sqlserver
http://ermanarslan.blogspot.com/2016/01/rdbms-oracle-to-sqlserver-dblink.htmlNeed your support
i am following oracle note id to install postress odbc driver.
Problems Configuring Database Gateway For ODBC (DG4ODBC) to Connect To Postgres ( Doc ID 881667.1 )
Downloaded latest file from source psqlodbc-13.00.0000.tar.gz as mentioned in document.
untar it and ran configure command
[root@erpsupportdb satish]# cd psqlodbc-13.00.0000
[root@erpsupportdb psqlodbc-13.00.0000]# pwd
/ERPShareddrive/ERP/opm/satish/psqlodbc-13.00.0000
[root@erpsupportdb psqlodbc-13.00.0000]# ./configure --prefix=/usr/psqlodbc --enable-pthreads
checking for a BSD-compatible install... /bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /bin/mkdir -p
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking whether make supports nested variables... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking whether gcc understands -c and -o together... yes
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking how to run the C preprocessor... gcc -E
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking size of long... 8
checking size of long int... 8
checking size of void *... 8
checking for long long... yes
checking for signed char... yes
checking for ssize_t... yes
checking for size_t... yes
checking -Wall is a valid compile option... yes
checking for odbc_config... /bin/odbc_config
configure: using /usr/include /usr/lib64
configure: using -L/usr/lib64 -lodbc for regression test
checking last argument to SQLColAttribute is SQLLEN *... yes
checking for pg_config... no
checking for prove... prove
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking how to print strings... printf
checking for a sed that does not truncate output... /bin/sed
checking for fgrep... /bin/grep -F
checking for ld used by gcc... /bin/ld
checking if the linker (/bin/ld) is GNU ld... yes
checking for BSD- or MS-compatible name lister (nm)... /bin/nm -B
checking the name lister (/bin/nm -B) interface... BSD nm
checking whether ln -s works... yes
checking the maximum length of command line arguments... 1966080
checking whether the shell understands some XSI constructs... yes
checking whether the shell understands "+="... yes
checking how to convert x86_64-unknown-linux-gnu file names to x86_64-unknown-linux-gnu format... func_convert_file_noop
checking how to convert x86_64-unknown-linux-gnu file names to toolchain format... func_convert_file_noop
checking for /bin/ld option to reload object files... -r
checking for objdump... objdump
checking how to recognize dependent libraries... pass_all
checking for dlltool... dlltool
checking how to associate runtime and link libraries... printf %s\n
checking for ar... ar
checking for archiver @FILE support... @
checking command to parse /bin/nm -B output from gcc object... ok
::::
checking for pthread_create in -lpthreads... no
checking for pthread_create in -lpthread... yes
checking for PQsetSingleRowMode in -lpq... no
configure: error: libpq library version >= 9.2 is required
1)How can we fi this "configure: error: libpq library version >= 9.2 is required"
2)Is this step fine to install unixodbc?
[root@erpsupportdb ~]# yum install unixODBC*
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Package unixODBC-2.3.1-11.el7.x86_64 already installed and latest version
Package unixODBC-devel-2.3.1-11.el7.x86_64 already installed and latest version
Nothing to do
[root@erpsupportdb ~]#
Thanks You