Thread: Report: PostgreSQL 7.1RC4 works on SGI Irix 6.5

Hi,

I have managed to get PostgreSQL 7.1RC4 running on SGI Irix 6.5 without any
trouble.

A more complete report follows:
    OS: IRIX64 ver 6.5
    GNU make: 3.76.1
    bison: 1.25
    flex: 2.5.4 (are flex and bison even used anymore?)
    tcl/tk: 8.0
    perl: 5.6.0
    GNU readline: 4.0

I used the native C and C++ compilers (see below for 'gcc'). I am using the -n32
ABI.

My confguration was setup to include the includes and libraries in /usr/local as
that is where I installed tcl/tk and the GNU packages.

> setenv CC /usr/bin/cc
> setenv CXX /usr/bin/CC
> ./configure \
>         --prefix=/usr/local/pgsql \
>         --with-includes=/usr/local/include \
>         --with-libraries=/usr/local/lib \
>         --with-CXX \
>         --with-tcl \
>         --with-tclconfig=/usr/local/lib \
>         --with-tkconfig=/usr/local/lib \
>         --with-perl \
>         --enable-odbc

Running "gmake all" followed by "gmake check" leads to all tests passing (when
viewed by eye).  Two tests failed when run by "diff".

The first failure was "final decimal digit" errors in the geometry test. I won't
bother showing any of those failures.

The second failure was during the "join" test. It is due to the ordering of the
returned tuples. I report them only because the README asks me to so that an
ORDER BY clause may be considered.

> *** ./expected/join.out Sat Jan  6 18:03:42 2001
> --- ./results/join.out  Tue Apr 10 14:16:38 2001
> ***************
> *** 1731,1738 ****
>        | 6 | 6 | six   |
>        | 7 | 7 | seven |
>        | 8 | 8 | eight |
> -      |   |   | null  |
>        |   | 0 | zero  |
>   (13 rows)
>
>   SELECT '' AS "xxx", *
> --- 1731,1738 ----
>        | 6 | 6 | six   |
>        | 7 | 7 | seven |
>        | 8 | 8 | eight |
>        |   | 0 | zero  |
> +      |   |   | null  |
>   (13 rows)
>
>   SELECT '' AS "xxx", *
> ***************
> *** 1750,1757 ****
>        | 6 | 6 | six   |
>        | 7 | 7 | seven |
>        | 8 | 8 | eight |
> -      |   |   | null  |
>        |   | 0 | zero  |
>   (13 rows)
>
>   SELECT '' AS "xxx", *
> --- 1750,1757 ----
>        | 6 | 6 | six   |
>        | 7 | 7 | seven |
>        | 8 | 8 | eight |
>        |   | 0 | zero  |
> +      |   |   | null  |
>   (13 rows)
>
>   SELECT '' AS "xxx", *
> ***************
> *** 1799,1806 ****
>        | 6 | 6 | six   |
>        | 7 | 7 | seven |
>        | 8 | 8 | eight |
> -      |   |   | null  |
>        |   | 0 | zero  |
>        |   |   |       |
>        |   |   |       |  0
>   (15 rows)
> --- 1799,1806 ----
>        | 6 | 6 | six   |
>        | 7 | 7 | seven |
>        | 8 | 8 | eight |
>        |   | 0 | zero  |
> +      |   |   | null  |
>        |   |   |       |
>        |   |   |       |  0
>   (15 rows)
> ***************
> *** 1820,1827 ****
>        | 6 | 6 | six   |
>        | 7 | 7 | seven |
>        | 8 | 8 | eight |
> -      |   |   | null  |
>        |   | 0 | zero  |
>        |   |   |       |
>        |   |   |       |  0
>   (15 rows)
> --- 1820,1827 ----
>        | 6 | 6 | six   |
>        | 7 | 7 | seven |
>        | 8 | 8 | eight |
>        |   | 0 | zero  |
> +      |   |   | null  |
>        |   |   |       |
>        |   |   |       |  0
>   (15 rows)

=============================================================================
Back in January, Tom Lane asked if I (or anyone) could compile PostgreSQL on
Irix with gcc. I have finally gotten around to try and I have failed.

I am running gcc version 2.95.2

I alter the configure I list above so that 'gcc' and 'g++' are used instead of
'cc' and 'CC'. The compilation goes smoothly for a while and then bombs out with
some errors about undefined variables. I have not followed up on these, but I
have included the tail end of the 'gmake all' output in case anyone else wants
to have a look:

> /usr/local/bin/gcc  -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -I/usr/local/include
-U_NO_XOPEN4 -c freelist.c -o freelist.o 
> /usr/local/bin/gcc  -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -I/usr/local/include
-U_NO_XOPEN4 -c localbuf.c -o localbuf.o 
> /usr/local/bin/gcc  -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -I/usr/local/include
-U_NO_XOPEN4 -c s_lock.c -o s_lock.o 
> s_lock.c: In function `s_lock':
> s_lock.c:134: warning: passing arg 1 of pointer to function discards qualifiers from pointer target type
> s_lock.c: At top level:
> s_lock.c:234: warning: `tas_dummy' defined but not used
> as: Error: /var/tmp/ccQWBkF9.s, line 421: undefined assembler operation: .global
>       .global tas
> gmake[4]: *** [s_lock.o] Error 1
> gmake[4]: Leaving directory `/usr/cb-share/Src/PostgreSQL/postgresql-7.1rc4/src/backend/storage/buffer'
> gmake[3]: *** [buffer-recursive] Error 2
> gmake[3]: Leaving directory `/usr/cb-share/Src/PostgreSQL/postgresql-7.1rc4/src/backend/storage'
> gmake[2]: *** [storage-recursive] Error 2
> gmake[2]: Leaving directory `/usr/cb-share/Src/PostgreSQL/postgresql-7.1rc4/src/backend'
> gmake[1]: *** [all] Error 2
> gmake[1]: Leaving directory `/usr/cb-share/Src/PostgreSQL/postgresql-7.1rc4/src'
> gmake: *** [all] Error 2

I don't have a lot of time to work on this, but if someone has suggestions or
some patches to fix this, I'll try to compile it again with gcc.

Cheers,
Mark

--
Mark Dalphin                          email: mdalphin@amgen.com
Mail Stop: 29-2-A                     phone: +1-805-447-4951 (work)
One Amgen Center Drive                       +1-805-375-0680 (home)
Thousand Oaks, CA 91320                 fax: +1-805-499-9955 (work)

Mark Dalphin writes:

> Back in January, Tom Lane asked if I (or anyone) could compile PostgreSQL on
> Irix with gcc. I have finally gotten around to try and I have failed.

Compiling PostgreSQL on Irix with GCC won't work because of a GCC bug (so
SGI claims).  Therefore it seems no one ever bothered to introduce support
for it in PostgreSQL.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

Peter Eisentraut wrote:
>
> Mark Dalphin writes:
>
> > Back in January, Tom Lane asked if I (or anyone) could compile PostgreSQL on
> > Irix with gcc. I have finally gotten around to try and I have failed.
>
> Compiling PostgreSQL on Irix with GCC won't work because of a GCC bug (so
> SGI claims).  Therefore it seems no one ever bothered to introduce support
> for it in PostgreSQL.

Ok, but GCC is continually evolving. Does SGI state which version of GCC has
this bug, or are we talking about a "design decision" where SGI and Gnu differ?

I thought this was worth trialling because there seems to be several messages
per year from people who try to compile PostgreSQL under Irix, using GCC.
[Personally, I find the native CC to be excellant and it seems to make fast
code, however, it appears that many people can't or won't buy the native CC
license.]

I suggest that if PostgreSQL can't be made available via GCC under Irix, then
the binaries should be made available ("Who'll bell the cat?").  There has been
some correspondence with the people at the SGI "freeware" site; has that been
formalized so that recent versions of PostgreSQL are available?  I'm thinking
something like an email to them at the time of a major release? I suppose that I
could CC them with my report of a successful compile, but as I am outside of the
developer's circle, I feel that is a bit presumptuous.

Mark

--
Mark Dalphin                          email: mdalphin@amgen.com
Mail Stop: 29-2-A                     phone: +1-805-447-4951 (work)
One Amgen Center Drive                       +1-805-375-0680 (home)
Thousand Oaks, CA 91320                 fax: +1-805-499-9955 (work)