Re: PostgreSQL ODBC driver for OSX 10.8

Hi, guys,
I downloaded the latest sources, but the configure failed.
I have OSX 10.8 here.

Which version of the driver is compatible?

[code]
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]

Thank you.


On Thu, Dec 1, 2016 at 12:01 PM, Adrian Klaver
<adrian.klaver@aklaver.com> wrote:
> On 12/01/2016 08:41 AM, Igor Korot wrote:
>>
>> Adrian,
>>
>> On Thu, Dec 1, 2016 at 11:37 AM, Adrian Klaver
>> <adrian.klaver@aklaver.com> wrote:
>>>
>>> On 12/01/2016 08:01 AM, Igor Korot wrote:
>>>>
>>>>
>>>>  Hi, ALL,
>>>> This is my first post here.
>>>> I have actually 2 questions which are kind of related.
>>>>
>>>> 1. Is there an OSX version of the ODBC PostgreSQL driver?
>>>> 1a. If there is none - is there an instructions on how to build and
>>>> install it?
>>>
>>>
>>>
>>> https://odbc.postgresql.org/docs/unix-compilation.html
>>
>>
>> I presume there is no OSX distribution file (.dmg), right?
>> Which means I'm forced to build it myself...
>
>
> Should have added previously, there is a separate mailing list for psqlodbc:
>
> https://www.postgresql.org/list/pgsql-odbc/
>
> That would probably be a good place to ask whether having a project dmg
> version is possible.
>
>
>>
>>>
>>>> 2. Is PostgreSQL ODBC driver works with iODBC?
>>>
>>>
>>>
>>> See above.
>>
>>
>> Thank you.
>>
>>>
>>>>
>>>> Thank you.
>>>>
>>>>
>>>
>>>
>>> --
>>> Adrian Klaver
>>> adrian.klaver@aklaver.com
>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com