Hi, Adrian,
On Fri, Dec 2, 2016 at 1:29 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
> On 12/01/2016 08:47 PM, Igor Korot wrote:
>>
>> Hi, Tom,
>>
>> On Thu, Dec 1, 2016 at 10:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>>
>>> Igor Korot <ikorot01@gmail.com> writes:
>>>>
>>>> This is what I get trying to compile latest source:
>>>
>>>
>>>>> checking for PQsetSingleRowMode in -lpq... no
>>>>> configure: error: libpq library version >= 9.2 is required
>>>
>>>
>>> Apple does ship a copy of libpq in /usr/lib, but it's generally a bit
>>> back-rev, and you're working in a macOS release that's itself several
>>> years out of date. You'll need to install a newer libpq to satisfy this
>>> ODBC version, evidently.
>>
>>
>> Is there a way to see what version of PostgreSQL is installed on
>> the system?
>> Because then it would be easy to find out what version of ODBC
>> driver I should have to connect.
>> Or maybe I already have the driver, since I have iODBC installed?
>
>
> A question I should have asked earlier, is it a requirement that ODBC be
> used for the connection?
>
> In other words is this a third party app needing ODBC or something you wrote
> that you want to connect via ODBC?
This is a software I'm writing and for testing purposes I need to use it.
It is cross-platform cross-database one.
One of the use-cases is to connect to the PostgreSQL thru the ODBC.
BTW, is there another way (a "native" way to talk to PostgreSQL server?
Thank you.
>
>
>>
>> Just checked - driver is not there.
>>
>> Thank you.
>>
>>>
>>> There isn't any separate distribution of libpq alone; you need to
>>> build and install all of Postgres into, say, /usr/local. That's
>>> not hard, but if you don't enjoy rolling it all yourself, you might
>>> want to consider installing from MacPorts or Homebrew.
>>>
>>> regards, tom lane
>>
>>
>>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com