Re: pg 10.1 missing libpq in postgresql-devel - Mailing list pgsql-general

On 01/29/2018 11:18 AM, support-tiger wrote:
> On 01/27/2018 06:43 PM, Adrian Klaver wrote:
> 
>> On 01/27/2018 04:34 PM, support-tiger wrote:
>>> sorry for delay but ran some tests on older version pg gem - still fails
>>
>> With what error message?
>>
>> What Ruby gem?
>>
>>>
>>> it fails on building the config file with simply missing libpq-fe.h, 
>>> cannot find libpq-fe.h
>>
>> Well it is there:
>>
>> rpm -qlp postgresql10-devel-10.1-1PGDG.f27.x86_64.rpm | grep libpq-fe.h
>> warning: postgresql10-devel-10.1-1PGDG.f27.x86_64.rpm: Header V4 
>> DSA/SHA1 Signature, key ID 442df0f8: NOKEY
>> /usr/pgsql-10/include/libpq-fe.h
>>
>>>
>>> I suspect it is a problem with using the pgdg repository and that 
>>> postgresql get "10" added to them ie postgresql10-devel and maybe the 
>>> gem code does not recognize that.   Since vers 10 is not breaking it 
>>> does not make sense (i guess fedora)  to rename vers 10 with the "10" 
>>> - maybe they just love the python 2 / 3 fiasco and want to extend it 
>>> to postgresql.
>>
>> Previous versions used version numbering also:
>>
>> https://yum.postgresql.org/9.6/fedora/fedora-26-x86_64/
>>
>> postgresql96-devel-9.6.6-1PGDG.f26.x86_64.rpm
>>
>> My guess it that the config script for the gem is not taking into 
>> account that Postgres changed from a three part versioning system 
>> X.Y.z to a two part system X.y(where lower case is minor version) from 
>> 9.6.0 to 10.1.
> 
> could be, cannot find the config file in the repository - specifies to 
> use a pg-config file to build the gem but no trace of such a config file

It is not looking for a file named pg-config, it is looking for a 
program named pg_config.

See:

https://deveiate.org/code/pg/

gem install pg -- --with-pg-config=<path to pg_config>


Try something like below to verify pg_config is installed(I'm sure it is):

aklaver@tito:~> pg_config
BINDIR = /usr/local/pgsql96/bin
DOCDIR = /usr/local/pgsql96/share/doc
HTMLDIR = /usr/local/pgsql96/share/doc

...

LIBS = -lpgcommon -lpgport -lxml2 -lssl -lcrypto -lz -lreadline -lrt 
-lcrypt -ldl -lm
VERSION = PostgreSQL 9.6.6

*IMPORTANT* If you have more then one instance of Postgres installed you 
will have more then one pg_config binary, so it is important that you 
point the gem install at the correct one.

> 
> thks anyway for your help.  had emailed the pg gem leads but no response 
> and github issues are blocked (duh)  - can't depend on this -will just 
> make a faster transition to Crystal - the pg shard in Crystal loaded 
> okay on Fedora with the 10.1

Are you talking about this?:

https://github.com/ged/ruby-pg

The above is a Git mirror of the 'real' repo, which is on BitBucket:

https://bitbucket.org/ged/ruby-pg/wiki/Home

You will find an issues page there.
> 
> 
> 
> 
>>
>>>
>>>
>>>
>>>
>>> On 01/25/2018 03:59 PM, Adrian Klaver wrote:
>>>> On 01/25/2018 12:20 PM, support-tiger wrote:
>>>>> running postgresql 10.1 on Fedora 27. Cannot install ruby pg gem 
>>>>> due to missing libpq-fe.h file. This is usually found in 
>>>>> postgresql-devel but 
>>>>
>>>> What was the error message returned when you tried to install 
>>>> originally?
>>>>
>>>>> it is not in fedora 27 postgresql10-devel. If install 
>>>>> postgresql-devel (9.6) the gem installs without problem but afraid 
>>>>> this will interfere with 10.1  How can we install the necessary 
>>>>> libpq-fe.h  ? thks
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com