Re: Fail to install psqlodbc due to libpq version incorrect

> Actually should probably be:

> rpm -qf /opt/freeware/lib/libpq.so

# rpm -qf /opt/freeware/lib/libpq.so
file /opt/freeware/lib/libpq.so: A file or directory in the path name does not exist.

# find / -name libpq.*so*
/opt/freeware/lib/libpq.so.5
/opt/freeware/lib64/libpq.so.5

# rpm -qf /opt/freeware/lib/libpq.so.5
postgresql-libs-9.2.9-1

# rpm -qf /opt/freeware/lib64/libpq.so.5
postgresql-libs-9.2.9-1

The Administrator has no idea.
From the result above, it looks like libpq was installed by an old version of postgresql.
As I know, my colleague tried to install the latest version of postgresql and got the same error as me. Then she tried to install an older version that should be 9.2.9.
I wonder libpq should be a prerequisite or a component of the installation package...

-----Original Message-----
From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
Sent: 03, July, 2017 09:26 PM
To: Joe CT NG; 'pgsql-odbc(at)postgresql(dot)org'
Subject: Re: [ODBC] Fail to install psqlodbc due to libpq version incorrect

On 07/02/2017 06:08 PM, Joe CT NG wrote:
>> Try:
>
>> rpm -qf libpq
>
>> to see if that returns anything useful.
>
> # rpm -qf libpq
> file libpq: A file or directory in the path name does not exist.

Try with full path:

rpm -qf /opt/freeware/lib/libpq

Though I have a suspicion that will not show anything either.

Do you administer the machine or does someone else?

If someone else you might try asking them how libpq got on it?

>
>
> -----Original Message-----
> From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
> Sent: 01, July, 2017 07:02 AM
> To: Joe CT NG; 'pgsql-odbc(at)postgresql(dot)org'
> Subject: Re: [ODBC] Fail to install psqlodbc due to libpq version incorrect
>
> On 06/29/2017 06:46 PM, Joe CT NG wrote:
>> Hi Adrian,
>>
>>> How did libpq get on your system?
>> I just find it at /opt/freeware/lib/ and /opt/freeware/lib64/
>
> Try:
>
> rpm -qf libpq
>
> to see if that returns anything useful.
>
>
>>
>>> Where is the Postgres instance located, on the same machine or somewhare else?
>> I have Oracle and Gateway on AIX and going to install psqlodbc on it.
>> Postgres is on a Linux machine.
>>
>> Thanks,
>> Joe
>>
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
>
> "Consider the environment - think before printing!"
>
> ________________________________
>
> This message and any attachment are confidential and it may be a criminal offence for you to disclose or use them without authority. Please follow the link for further information:
> http://www.sfc.hk/web/EN/emailnote.html
>
> "Consider the environment - think before printing!"
>

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

________________________________

This message and any attachment are confidential and it may be a criminal offence for you to disclose or use them without authority. Please follow the link for further information:
http://www.sfc.hk/web/EN/emailnote.html

"Consider the environment - think before printing!"