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@xxxxxxxxxx> To: AgentM <agentm@xxxxxxxxxxxxxxxxxxxxx> References: <42A722C2.E5CDE439@xxxxxxxxxx> <1AF75916-6B2E-4708-ADC2-6599946626EA@xxxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxx > |-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|- > > -- > 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
