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

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

Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <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

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
i686 and provide right folder name.

Thanks,

Devrim GÜNDÜZ <devrim@gunduz.org> wrote on 07/12/2012 01:19:18 PM:

Hi,

On Thu, 2012-07-12 at 16:36 -0400, Tom Lane wrote:

Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <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

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ÜNDÜZ <devrim@gunduz.org> wrote on 07/12/2012 01:42:56 PM: