Re: Postgres 7 on IRIX

Any chance you can test our current PostgreSQL version and let us know
what needs changing for Irix? I think it will work better now.

Content-Description: message body text

> Hernandez Alvarez Alfredo writes:
> > Thanks. I tried making a link from the cc to
> > /usr/freeware/bin/gcc... cant compile... I will try removing the mips
> > compiler...
>
> That won't help. Your problem is that configure has decided to use
> the MIPSpro compiler and set the CFLAGS for that. gcc doesn't grok
> them.
>
> Try making another template file, e.g. template/irix6_gcc. Merge
> template/irix5 and one or more of the _gcc templates. Then configure
> with
>
> ./configure --with-template=irix6_gcc
>
>
> For what it's worth I've just been building PostgreSQL 7.0.2 on IRIX
> 6.5.5m with the native MIPSpro 7.3 compilers. Both -n32 and -64
> versions have been tried. -o32 is obsolescent and was not considered.
>
> The -64 version gives 34 warnings about 64-bit pointers being stored
> in 32-bit integers. That makes whatever is built unsafe IMHO. How
> well does PostgreSQL build on Alpha and other 64-bit systems?
>
> One worrying problem is that when optimized -O2 both -n32 and -64
> versions failed regression tests such as oidjoins. An example is
>
> SELECT oid, pg_aggregate.aggtransfn1
> FROM pg_aggregate
> WHERE pg_aggregate.aggtransfn1 != 0 AND
> NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid =
> pg_aggregate.aggtransfn1);
> ERROR: getattproperties: no attribute tuple 1255 -2
>
> I have not investigated further. Compiling without optimization seems
> okay.
>
>
> So the current state of affairs is that it is built -n32 -g and passes
> the regression tests. To do this I've done the following.
>
> 1) Created a new template/irix6 containing
Content-Description: Template for IRIX 6.5

[ Attachment, skipping... ]
Content-Description: message body text

>
> This is picked up by "./configure --with-template=irix6" though
> presumably the configure script could be updated.
>
> Note that the LD entry gets overridden somewhere later. My kludge for
> linker errors such as
>
> ld -r -o SUBSYS.o heaptuple.o indextuple.o indexvalid.o printtup.o
> scankey.o tupdesc.o
> ld: FATAL 12 : Expecting o32 objects: heaptuple.o is n32.
>
> is to export the environment variable "SGI_ABI=-n32".
>
>
> 2) After running configure, edit config.h to get around the accept bug
> http://www.postgresql.org/mhonarc/pgsql-ports/2000-05/msg00042.html
>
>
> 3) Edit tests/regress/resultmap to add entries for IRIX.
>
Content-Description: New resultmap entries for IRIX 6

[ Attachment, skipping... ]
Content-Description: message body and .signature

>
> Note that the geometry test still fails. I've eyeballed the
> differences to be just due to FP precision but it needs to be checked
> thoroughly.
>
> (I will copy item (3) to pgsql-patches.)
>
> --
> Pete Forman -./\.- Disclaimer: This post is originated
> Western Geophysical -./\.- by myself and does not represent
> pete(dot)forman(at)westgeo(dot)com -./\.- the opinion of Baker Hughes or
> http://www.crosswinds.net/~petef -./\.- its divisions.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026