Thread: BUG #6729: Install of postgresql-devel for x86_84 and i686 fails

BUG #6729: Install of postgresql-devel for x86_84 and i686 fails

From
ysharma@cymer.com
Date:
The following bug has been logged on the website:

Bug reference:      6729
Logged by:          Yogesh Sharma
Email address:      ysharma@cymer.com
PostgreSQL version: 9.1.4
Operating system:   CentOS 6.3
Description:=20=20=20=20=20=20=20=20

For compilation of 64bit as well 32bit program I am trying to install both
versions. Here is error:

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D
 Package                                Arch                       Version=
=20=20
                            Repository=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20
                 Size
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D
Installing:
 postgresql91-devel                     i686=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20=20
9.1.4-1PGDG.rhel6=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20
/postgresql91-devel-9.1.4-1PGDG.rhel6.i686                       5.4 M
 postgresql91-devel                     x86_64=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20
9.1.4-1PGDG.rhel6=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20
/postgresql91-devel-9.1.4-1PGDG.rhel6.x86_64                     6.2 M

Transaction Summary
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D
Install       2 Package(s)

Total size: 12 M
Installed size: 12 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test


Transaction Check Error:
  file /usr/pgsql-9.1/lib/libecpg.a conflicts between attempted installs of
postgresql91-devel-9.1.4-1PGDG.rhel6.x86_64 and
postgresql91-devel-9.1.4-1PGDG.rhel6.i686
  file /usr/pgsql-9.1/lib/libecpg_compat.a conflicts between attempted
installs of postgresql91-devel-9.1.4-1PGDG.rhel6.x86_64 and
postgresql91-devel-9.1.4-1PGDG.rhel6.i686
  file /usr/pgsql-9.1/lib/libpgport.a conflicts between attempted installs
of postgresql91-devel-9.1.4-1PGDG.rhel6.x86_64 and
postgresql91-devel-9.1.4-1PGDG.rhel6.i686
  file /usr/pgsql-9.1/lib/libpgtypes.a conflicts between attempted installs
of postgresql91-devel-9.1.4-1PGDG.rhel6.x86_64 and
postgresql91-devel-9.1.4-1PGDG.rhel6.i686
  file /usr/pgsql-9.1/lib/libpq.a conflicts between attempted installs of
postgresql91-devel-9.1.4-1PGDG.rhel6.x86_64 and
postgresql91-devel-9.1.4-1PGDG.rhel6.i686
  file /usr/pgsql-9.1/lib/pgxs/src/Makefile.global conflicts between
attempted installs of postgresql91-devel-9.1.4-1PGDG.rhel6.x86_64 and
postgresql91-devel-9.1.4-1PGDG.rhel6.i686

Error Summary
-------------

Re: BUG #6729: Install of postgresql-devel for x86_84 and i686 fails

From
Devrim GÜNDÜZ
Date:
Hi,

It is not a bug, but it might be a missing feature (and I'm not sure how
to fix it :-) )

Regards,

On Wed, 2012-07-11 at 23:16 +0000, ysharma@cymer.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      6729
> Logged by:          Yogesh Sharma
> Email address:      ysharma@cymer.com
> PostgreSQL version: 9.1.4
> Operating system:   CentOS 6.3
> Description:
>
> For compilation of 64bit as well 32bit program I am trying to install both
> versions. Here is error:
>
>
================================================================================================================================================================================
>  Package                                Arch                       Version
>                             Repository
>                  Size
>
================================================================================================================================================================================
> Installing:
>  postgresql91-devel                     i686
> 9.1.4-1PGDG.rhel6
> /postgresql91-devel-9.1.4-1PGDG.rhel6.i686                       5.4 M
>  postgresql91-devel                     x86_64
> 9.1.4-1PGDG.rhel6
> /postgresql91-devel-9.1.4-1PGDG.rhel6.x86_64                     6.2 M
>
> Transaction Summary
>
================================================================================================================================================================================
> Install       2 Package(s)
>
> Total size: 12 M
> Installed size: 12 M
> Is this ok [y/N]: y
> Downloading Packages:
> Running rpm_check_debug
> Running Transaction Test
>
>
> Transaction Check Error:
>   file /usr/pgsql-9.1/lib/libecpg.a conflicts between attempted installs of
> postgresql91-devel-9.1.4-1PGDG.rhel6.x86_64 and
> postgresql91-devel-9.1.4-1PGDG.rhel6.i686
>   file /usr/pgsql-9.1/lib/libecpg_compat.a conflicts between attempted
> installs of postgresql91-devel-9.1.4-1PGDG.rhel6.x86_64 and
> postgresql91-devel-9.1.4-1PGDG.rhel6.i686
>   file /usr/pgsql-9.1/lib/libpgport.a conflicts between attempted installs
> of postgresql91-devel-9.1.4-1PGDG.rhel6.x86_64 and
> postgresql91-devel-9.1.4-1PGDG.rhel6.i686
>   file /usr/pgsql-9.1/lib/libpgtypes.a conflicts between attempted installs
> of postgresql91-devel-9.1.4-1PGDG.rhel6.x86_64 and
> postgresql91-devel-9.1.4-1PGDG.rhel6.i686
>   file /usr/pgsql-9.1/lib/libpq.a conflicts between attempted installs of
> postgresql91-devel-9.1.4-1PGDG.rhel6.x86_64 and
> postgresql91-devel-9.1.4-1PGDG.rhel6.i686
>   file /usr/pgsql-9.1/lib/pgxs/src/Makefile.global conflicts between
> attempted installs of postgresql91-devel-9.1.4-1PGDG.rhel6.x86_64 and
> postgresql91-devel-9.1.4-1PGDG.rhel6.i686
>
> Error Summary
> -------------
>
>
>


--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Re: BUG #6729: Install of postgresql-devel for x86_84 and i686 fails

From
Tom Lane
Date:
Devrim GÜNDÜZ <devrim@gunduz.org> writes:
> It is not a bug, but it might be a missing feature (and I'm not sure how
> to fix it :-) )

It's fairly common for -devel packages of different architectures to
conflict.  If you were to try to fix it, you'd likely need the 64-bit
versions to install their stuff into .../lib64/ not .../lib/.
Not sure how practical such a change is at this late date.
        regards, tom lane


Re: BUG #6729: Install of postgresql-devel for x86_84 and i686 fails

From
Devrim GÜNDÜZ
Date:
Hi,

On Thu, 2012-07-12 at 16:36 -0400, Tom Lane wrote:
> Devrim GÜNDÜZ <devrim@gunduz.org> writes:
> > It is not a bug, but it might be a missing feature (and I'm not sure
> how
> > to fix it :-) )
>
> It's fairly common for -devel packages of different architectures to
> conflict.  If you were to try to fix it, you'd likely need the 64-bit
> versions to install their stuff into .../lib64/ not .../lib/.

Well, there lies the problem. My packages push everything
under /usr/pgsql-9.1 , and libs go to /usr/pgsql-9.1/lib. A

> Not sure how practical such a change is at this late date.

What if I build *9.2* with --libdir=/usr/pgsql-9.1/lib64 for x86_64, and
then push 32-bit packages to /usr/pgsql-9.1/lib ?

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Re: BUG #6729: Install of postgresql-devel for x86_84 and i686 fails

From
Yogesh_Sharma@Cymer.com
Date:
Hi Devrim,

How things are going, long time since we exchanged any email.

May be different lib folders can be used:
/usr/pgsql-9.1/lib/libecpg.a
/usr/pgsql-9.1/lib64/libecpg.a

glibc-devel.i686 and glibc-devel.x86_64 does similar thing.

rpm -ql glibc-devel.i686 |grep .a$
/usr/lib/libbsd-compat.a
/usr/lib/libbsd.a
/usr/lib/libc_nonshared.a
/usr/lib/libg.a
/usr/lib/libieee.a
/usr/lib/libmcheck.a
/usr/lib/libpthread_nonshared.a
/usr/lib/librpcsvc.a

rpm -ql glibc-devel.x86_64 |grep .a$
/usr/lib64/libbsd-compat.a
/usr/lib64/libbsd.a
/usr/lib64/libc_nonshared.a
/usr/lib64/libg.a
/usr/lib64/libieee.a
/usr/lib64/libmcheck.a
/usr/lib64/libpthread_nonshared.a
/usr/lib64/librpcsvc.a

It does affects pg_config as now pg_config has to be aware of x86_64 and=20
i686 and provide right folder name.

Thanks,

Devrim G=DCND=DCZ <devrim@gunduz.org> wrote on 07/12/2012 01:19:18 PM:

>=20
> Hi,
>=20
> It is not a bug, but it might be a missing feature (and I'm not sure how
> to fix it :-) )
>=20
> Regards,
>=20
> On Wed, 2012-07-11 at 23:16 +0000, ysharma@cymer.com wrote:
> > The following bug has been logged on the website:
> >=20
> > Bug reference:      6729
> > Logged by:          Yogesh Sharma
> > Email address:      ysharma@cymer.com
> > PostgreSQL version: 9.1.4
> > Operating system:   CentOS 6.3

Re: BUG #6729: Install of postgresql-devel for x86_84 and i686 fails

From
Yogesh_Sharma@Cymer.com
Date:
What about following:

%ifarch x86_64
%define PGLIBDIR lib64
%else
%define PGLIBDIR lib
%endif

In %install  use /usr/pgsql-9.1/%{LIBDIR}/
same in %files

pg_config impacted ?


Thanks,
Yogesh Sharma

Devrim G=DCND=DCZ <devrim@gunduz.org> wrote on 07/12/2012 01:42:56 PM:

>=20
> Hi,
>=20
> On Thu, 2012-07-12 at 16:36 -0400, Tom Lane wrote:
> > Devrim =3D?ISO-8859-1?Q?G=3DDCND=3DDCZ?=3D <devrim@gunduz.org> writes:
> > > It is not a bug, but it might be a missing feature (and I'm not sure
> > how
> > > to fix it :-) )
> >=20
> > It's fairly common for -devel packages of different architectures to
> > conflict.  If you were to try to fix it, you'd likely need the 64-bit
> > versions to install their stuff into .../lib64/ not .../lib/.
>=20
> Well, there lies the problem. My packages push everything
> under /usr/pgsql-9.1 , and libs go to /usr/pgsql-9.1/lib. A
>=20
> > Not sure how practical such a change is at this late date.
>=20
> What if I build *9.2* with --libdir=3D/usr/pgsql-9.1/lib64 for x86_64, and
> then push 32-bit packages to /usr/pgsql-9.1/lib ?
>=20=