Re: Is there a way to build 32-bit mode on 64-bit Linux boxes?

Subject: Re: [ADMIN] Is there a way to build 32-bit mode on 64-bit Linux
boxes?
Date: Wed, 08 Jun 2005 11:34:42 -0700
From: Wayne Schroeder <waynes(at)san(dot)rr(dot)com>
To: AgentM <agentm(at)themactionfaction(dot)com>
References: <42A722C2(dot)E5CDE439(at)san(dot)rr(dot)com>
<1AF75916-6B2E-4708-ADC2-6599946626EA(at)themactionfaction(dot)com>

Thanks for responding, everyone (Ross, Joshua, and AgentM), you all have
similar questions so I'll respond to them all here. (I'm glad this is
finally working, don't know why my work email (linux emacs) didn't get
thru).

My App is the Metadata Catalog (MCAT) of the SDSC Storage Resource
Broker -
(see http://www.sdsc.edu/srb/ ). The MCAT runs on various OSes (various
versions of Linux, Mac OS X, Solaris, AIX, etc (not Windows yet, but our
client programs do) and can use various RDBMSs (Postgres, Oracle, DB2,
etc). The SRB provides a distributed file system, datagrid, or digital
library, depending how you look at it (see web site and FAQ); and is
used in
various large-scale scientific (NSF) or archival projects (NARA), etc.
SRB/MCAT is freely available to academic and government sites (altho it
is
not, unfortunately, open source).

Quite a few SRB sites are now using Postgresql, at least for testing and
experimentation, partly because I developed an install script that
configures and builds everything (postgres, odbc, and srb) fairly
easily.
So I know little about configuring and building odbc and postgres, but I
don't know much about them beyond that.

The MCAT code isn't ready for 64-bit addressing yet. It's on our todo
list,
but it will be a fairly big project and it will be a while before we can
get
to it.

The MCAT process is using ODBC to talk to posgresql. It sounds like I
could
build MCAT and ODBC in 32-bit mode. But would ODBC then have any
problem
talking with a 64-bit postgresql server? You've confirmed that 32-bit
clients can talk to 64-bit postgres, but does that include ODBC too? I
think I tried to build ODBC in 32-bit mode, ran into some problems, and
wasn't sure this setup would work anyway. If you'all think that should
work, I'll try it again.

Thanks,

- Wayne -
http://users.sdsc.edu/~schroede/

AgentM wrote:

> Even if your app isn't 64-bit-ready, what does that have to do with
> postgresql? Not much changes when run as a 64-bit app except maybe
> that it is slower. Is there a specific issue you have come across
> that prevents you from using 64-bit postgresql? You can still use 32-
> bit compiled clients against a 64-bit postgresql server.
>
> On Jun 8, 2005, at 11:54 AM, Wayne Schroeder wrote:
>
> > I'm trying to build postgresql and odbc from source on x86_64 Linux
> > hosts but I need to run them in 32-bit addressing mode since my app is
> > not 64-bit ready yet.
> >
> > Simple test programs can be built as 32-bit apps (if the libraries are
> > installed) via gcc's -m32 option.
> >
> > I checked for postgres configure options to do something similar, but
> > didn't find anything. I experimented with setting environment
> > variable CFLAGS to -m32 and it does seem to be picked up by
> > configure/make, but then 'ld' gets errors:
> > /usr/bin/ld -r -o SUBSYS.o heaptuple.o indextuple.o indexvalid.o
> > printtup.o scankey.o tupdesc.o
> > /usr/bin/ld: Relocatable linking with relocations from format
> > elf32-i386 (heaptuple.o) to format elf64-x86-64 (SUBSYS.o) is not
> > supported
> > So ld needs some additional options of some sort, but it looks like
> > that would involve some complicated specifications of various
> > libraries.
> >
> > I checked the archives, but didn't see anything about this.
> >
> > Is there any way to do this? Any plans to add it? Any hints on what
> > I could try?
>
> |-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
> AgentM
> agentm(at)themactionfaction(dot)com
> |-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 6/8/05