Re: Distribution package for OSX

On 12/02/2016 07:38 PM, Igor Korot wrote:
> Hi, Adrian,
>
> On Fri, Dec 2, 2016 at 1:29 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(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?
>
> 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?

Using libpq:

https://www.postgresql.org/docs/9.5/static/libpq.html

There is also JDBC:

https://jdbc.postgresql.org/

Then there are all the other language bindings eg Python, PERL, etc. It
really depends on what you are calling native.

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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com