Re: Distribution package for OSX

On 12/01/2016 08:47 PM, Igor Korot wrote:
> Hi, Tom,
>
> On Thu, Dec 1, 2016 at 10:48 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Igor Korot <ikorot01(at)gmail(dot)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?

>
> 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(dot)klaver(at)aklaver(dot)com