Обсуждение: [BUGS] BUG #14728: Missing "pg_config.h" in the "postgresql96-devel" package

The following bug has been logged on the website:

Bug reference:      14728
Logged by:          Hiroshi YUKI
Email address:      yuki@clear-code.com
PostgreSQL version: 9.6.3
Operating system:   CentOS 6.9
Description:

When I build a software "pgroonga" from its source, it fails on CentOS 6.9
i386 (32bit) environment. On CentOS 6.9 x86_64, this problem doesn't
happen.

A header file "pg_co]nfig.h" is missing in directories both
"/usr/pgsql-9.6/include/" and "/usr/pgsql-9.6/include/server/".

For more details, please see an issue of PGroonga:
https://github.com/pgroonga/pgroonga/issues/47


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

On Mon, Jul 3, 2017 at 5:55 PM,  <yuki@clear-code.com> wrote:
> When I build a software "pgroonga" from its source, it fails on CentOS 6.9
> i386 (32bit) environment. On CentOS 6.9 x86_64, this problem doesn't
> happen.

This is not a bug of PostgreSQL itself.

> A header file "pg_co]nfig.h" is missing in directories both
> "/usr/pgsql-9.6/include/" and "/usr/pgsql-9.6/include/server/".

Are you sure that you installed postgresql-devel? I recall that CentOS
has that to allow compilation of modules.
-- 
Michael


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Hello,
>> A header file "pg_co]nfig.h" is missing in directories both>> "/usr/pgsql-9.6/include/" and
"/usr/pgsql-9.6/include/server/".>>Are you sure that you installed postgresql-devel? I recall that CentOS> has that to
allowcompilation of modules.
 

If the package "postgresql96-devel" equals to the one you said, yes.
Full steps to reproduce on my clean CentOS virtual box:

$ su
# yum install 
https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-centos96-9.6-3.noarch.rpm
# yum install postgresql96
# yum install postgresql96-server
# service postgresql-9.6 initdb
# chkconfig postgresql-9.6 on
# service postgresql-9.6 start
# yum install postgresql96-devel
# yum install -y 
https://packages.groonga.org/centos/groonga-release-1.3.0-1.noarch.rpm
# yum install -y --enablerepo=epel groonga-devel
# wget https://packages.groonga.org/source/pgroonga/pgroonga-1.2.3.tar.gz
# tar xvf pgroonga-1.2.3.tar.gz
# cd pgroonga-1.2.3
# PATH=/usr/pgsql-9.6/bin:$PATH make

I tried thiese steps on both CentOS 6.9 x86_64 (64bit):
https://app.vagrantup.com/centos/boxes/6
and CentOS 6.9 i386 (32bit):
https://app.vagrantup.com/bento/boxes/centos-6.9-i386
Then, the result is:
 * x86_64 => succeeded with existign pg_config.h * i386   => failed with missing pg_config.h

Or, do you mean that I must install "postgresql-devel" even if 
"postgresql96-devel" is already installed?


regards,

Michael Paquier wrote:
> On Mon, Jul 3, 2017 at 5:55 PM,  <yuki@clear-code.com> wrote:
>> When I build a software "pgroonga" from its source, it fails on CentOS 6.9
>> i386 (32bit) environment. On CentOS 6.9 x86_64, this problem doesn't
>> happen.
> 
> This is not a bug of PostgreSQL itself.
> 
>> A header file "pg_co]nfig.h" is missing in directories both
>> "/usr/pgsql-9.6/include/" and "/usr/pgsql-9.6/include/server/".
> 
> Are you sure that you installed postgresql-devel? I recall that CentOS
> has that to allow compilation of modules.
> 

-- 
結城 洋志 <YUKI Hiroshi>
E-mail: yuki@clear-code.com

株式会社クリアコード
〒170-0005 東京都豊島区南大塚3-29-9           中野ビル3階
TEL : 03-5927-9440
FAX : 03-5927-9441
WWW : http://www.clear-code.com/



-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Oops,
> # yum install> 
https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-centos96-9.6-3.noarch.rpm

Of course this URL is different for CentOS 6.9 i386. Actually I used 
correct URL for i386.


YUKI Hiroshi wrote:
> Hello,
> 
>   >> A header file "pg_co]nfig.h" is missing in directories both
>   >> "/usr/pgsql-9.6/include/" and "/usr/pgsql-9.6/include/server/".
>   >
>   > Are you sure that you installed postgresql-devel? I recall that CentOS
>   > has that to allow compilation of modules.
> 
> If the package "postgresql96-devel" equals to the one you said, yes.
> Full steps to reproduce on my clean CentOS virtual box:
> 
> $ su
> # yum install
> https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-centos96-9.6-3.noarch.rpm
> # yum install postgresql96
> # yum install postgresql96-server
> # service postgresql-9.6 initdb
> # chkconfig postgresql-9.6 on
> # service postgresql-9.6 start
> # yum install postgresql96-devel
> # yum install -y
> https://packages.groonga.org/centos/groonga-release-1.3.0-1.noarch.rpm
> # yum install -y --enablerepo=epel groonga-devel
> # wget https://packages.groonga.org/source/pgroonga/pgroonga-1.2.3.tar.gz
> # tar xvf pgroonga-1.2.3.tar.gz
> # cd pgroonga-1.2.3
> # PATH=/usr/pgsql-9.6/bin:$PATH make
> 
> I tried thiese steps on both CentOS 6.9 x86_64 (64bit):
> https://app.vagrantup.com/centos/boxes/6
> and CentOS 6.9 i386 (32bit):
> https://app.vagrantup.com/bento/boxes/centos-6.9-i386
> Then, the result is:
> 
>    * x86_64 => succeeded with existign pg_config.h
>    * i386   => failed with missing pg_config.h
> 
> Or, do you mean that I must install "postgresql-devel" even if
> "postgresql96-devel" is already installed?
> 
> 
> regards,
> 
> Michael Paquier wrote:
>> On Mon, Jul 3, 2017 at 5:55 PM,  <yuki@clear-code.com> wrote:
>>> When I build a software "pgroonga" from its source, it fails on CentOS 6.9
>>> i386 (32bit) environment. On CentOS 6.9 x86_64, this problem doesn't
>>> happen.
>>
>> This is not a bug of PostgreSQL itself.
>>
>>> A header file "pg_co]nfig.h" is missing in directories both
>>> "/usr/pgsql-9.6/include/" and "/usr/pgsql-9.6/include/server/".
>>
>> Are you sure that you installed postgresql-devel? I recall that CentOS
>> has that to allow compilation of modules.
>>
> 

-- 
結城 洋志 <YUKI Hiroshi>
E-mail: yuki@clear-code.com

株式会社クリアコード
〒170-0005 東京都豊島区南大塚3-29-9           中野ビル3階
TEL : 03-5927-9440
FAX : 03-5927-9441
WWW : http://www.clear-code.com/



-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Hi,

On Mon, 2017-07-03 at 08:55 +0000, yuki@clear-code.com wrote:
> When I build a software "pgroonga" from its source, it fails on CentOS 6.9
> i386 (32bit) environment. On CentOS 6.9 x86_64, this problem doesn't
> happen.
>
> A header file "pg_co]nfig.h" is missing in directories both
> "/usr/pgsql-9.6/include/" and "/usr/pgsql-9.6/include/server/".

This was a packaging issue, and we fixed it yesterday. Please update to 9.6.3-3
on RHEL 6 - i386.

Sorry for the inconvenience.

Regards,
--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Hi,

On Tue, 2017-07-04 at 08:58 +0900, Michael Paquier wrote:
> This is not a bug of PostgreSQL itself.

The community packaging bugs can also be reported here, so I don't see a
problem in here. 

Regards,
--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Hi,

Thank you for the package update! I've confirmed that now I can 
successfully build PGroonga on CentOS 6 i386. Thus I close PGroonga's 
tracked issue: https://github.com/pgroonga/pgroonga/issues/47

regards,

Devrim Gündüz wrote:
> 
> Hi,
> 
> On Mon, 2017-07-03 at 08:55 +0000, yuki@clear-code.com wrote:
>> When I build a software "pgroonga" from its source, it fails on CentOS 6.9
>> i386 (32bit) environment. On CentOS 6.9 x86_64, this problem doesn't
>> happen.
>>
>> A header file "pg_co]nfig.h" is missing in directories both
>> "/usr/pgsql-9.6/include/" and "/usr/pgsql-9.6/include/server/".
> 
> This was a packaging issue, and we fixed it yesterday. Please update to 9.6.3-3
> on RHEL 6 - i386.
> 
> Sorry for the inconvenience.
> 
> Regards,
> 

-- 
結城 洋志 <YUKI Hiroshi>
E-mail: yuki@clear-code.com

株式会社クリアコード
〒170-0005 東京都豊島区南大塚3-29-9           中野ビル3階
TEL : 03-5927-9440
FAX : 03-5927-9441
WWW : http://www.clear-code.com/



-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs