Re: Distribution package for OSX - Mailing list pgsql-odbc

Hi, Michael,

On Thu, Dec 1, 2016 at 8:14 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> On Fri, Dec 2, 2016 at 5:22 AM, Igor Korot <ikorot01@gmail.com> wrote:
>>  Hi,
>> I'm looking for a ready-to-use distribution package of the PostgreSQL ODBC
>> driver for OSX 10.8 (.dmg file).
>>
>> Is it readily available or I will have to build the driver manually?
>
> You will need to build it manually I am afraid. There are no official
> packages provided for OSX on odbc.postgresql.org.

This is what I get trying to compile latest source:

> Igors-MacBook-Air:buildMac igorkorot$ ../configure
> --with-iodbc=/Library/Frameworks/iODBC.framework/iODBC
> checking for a BSD-compatible install... /usr/bin/install -c
> checking whether build environment is sane... yes
> checking for a thread-safe mkdir -p... ../config/install-sh -c -d
> checking for gawk... no
> checking for mawk... no
> checking for nawk... no
> checking for awk... awk
> 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 -Wall is a valid compile option... yes
> ../configure: line 4390: /Library/Frameworks/iODBC.framework/iODBC:
> cannot execute binary file
> ../configure: line 4393: /Library/Frameworks/iODBC.framework/iODBC:
> cannot execute binary file
> configure: using
> checking last argument to SQLColAttribute is SQLLEN *... yes
> checking for pg_config... /usr/bin/pg_config
> checking for prove... prove
> checking build system type... x86_64-apple-darwin12.5.0
> checking host system type... x86_64-apple-darwin12.5.0
> checking how to print strings... printf
> checking for a sed that does not truncate output... /usr/bin/sed
> checking for grep that handles long lines and -e... /usr/bin/grep
> checking for egrep... /usr/bin/grep -E
> checking for fgrep... /usr/bin/grep -F
> checking for ld used by gcc...
> /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/ld
> checking if the linker
> (/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/ld)
> is GNU ld... no
> checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm
> checking the name lister (/usr/bin/nm) interface... BSD nm
> checking whether ln -s works... yes
> checking the maximum length of command line arguments... 196608
> checking whether the shell understands some XSI constructs... yes
> checking whether the shell understands "+="... yes
> checking how to convert x86_64-apple-darwin12.5.0 file names to
> x86_64-apple-darwin12.5.0 format... func_convert_file_noop
> checking how to convert x86_64-apple-darwin12.5.0 file names to
> toolchain format... func_convert_file_noop
> checking for /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/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... no
> checking for strip... strip
> checking for ranlib... ranlib
> checking command to parse /usr/bin/nm output from gcc object... ok
> checking for sysroot... no
> checking for mt... no
> checking if : is a manifest tool... no
> checking for dsymutil... dsymutil
> checking for nmedit... nmedit
> checking for lipo... lipo
> checking for otool... otool
> checking for otool64... no
> checking for -single_module linker flag... yes
> checking for -exported_symbols_list linker flag... yes
> checking for -force_load linker flag... yes
> checking how to run the C preprocessor... gcc -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 for dlfcn.h... yes
> checking for objdir... .libs
> checking if gcc supports -fno-rtti -fno-exceptions... yes
> checking for gcc option to produce PIC... -fno-common -DPIC
> checking if gcc PIC flag -fno-common -DPIC works... yes
> checking if gcc static flag -static works... no
> checking if gcc supports -c -o file.o... yes
> checking if gcc supports -c -o file.o... (cached) yes
> checking whether the gcc linker
> (/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/ld)
> supports shared libraries... yes
> checking dynamic linker characteristics... darwin12.5.0 dyld
> checking how to hardcode library paths into programs... immediate
> checking for dlopen in -ldl... yes
> checking whether a program can dlopen itself... yes
> checking whether a statically linked program can dlopen itself... yes
> checking whether stripping libraries is possible... yes
> checking if libtool supports shared libraries... yes
> checking whether to build shared libraries... yes
> checking whether to build static libraries... no
> checking for library containing SQLGetPrivateProfileString... -liodbcinst
> 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
> [/code]

As I said I have 10.8 that was orinally installed on the system.
And I will try to connect to 9.5.2  which is running on Linux.

Do you know which driver version I should use?

Thank you.

> --
> Michael