Dear Devrim,
	I have been using Postgres on Irix for over 8 years, and I have only
used the SGI provided compilers. GCC doesn't work well on Irix. In addition,
you can build a 64 bit version of PostgreSQL. Here's the script we used for
PostgreSQL 7.3.2:

#!/bin/ksh -x

./copy_local_files_for_build
export SGI_ABI=-64
cat >config.cache <<EOF
ac_cv_lib_nsl_main=${ac_cv_lib_nsl_main='no'}
ac_cv_prog_CPP=${ac_cv_prog_CPP='cc -E'}
ac_cv_prog_gcc=${ac_cv_prog_gcc=no}
ac_cv_prog_perl=${ac_cv_prog_perl=/stf/sys64/bin/perl}
EOF
gmake clean
CC="cc -64" \
AWK=awk \
INSTALL=/pg/postgresql-7.3.2/config/install-sh \
LDFLAGS="-rpath $POSTGRES_HOME/local/lib" \
./configure --prefix=/pg/postgresql-7.3.2 \
            --enable-hba \
            --with-pgport=6543 \
            --disable-locale \
            --enable-cassert \
            --with-template=irix5 \
            --with-includes="$POSTGRES_HOME/local/include $POSTGRES_HOME/local/include/readline" \
            --with-libs=$POSTGRES_HOME/local/lib \
            --without-CXX \
            --with-maxbackends=128 \
            --enable-debug \
            --without-java \
            --enable-odbc
gmake
LD_LIBRARY64_PATH=/pg/postgresql-7.3.2/src/interfaces/libpq:$LD_LIBRARY64_PATH gmake check
gmake install
export PATH=/pg/postgresql-7.3.2/bin:$PATH
initdb -D /pg/postgresql-7.3.2/data

------------------------------------------------------------------------

src/Makefile.custom is set to:

CUSTOM_CC = cc -64
LD += -64
MK_NO_LORDER = 1

The script copy_local_files_for_build is as follows:

#!/bin/sh

source="/stf/sys64"

if [ "$POSTGRES_HOME"x = x ]
then
    echo "No POSTGRES_HOME variable set."
    exit 1
fi

if [ ! -d $POSTGRES_HOME/local/lib ]
then
    mkdir -p $POSTGRES_HOME/local/lib
fi

/usr/local/bin/tarcp $source/include/readline $POSTGRES_HOME/local/include/readline
cp ${source}/lib/libz* $POSTGRES_HOME/local/lib
cp ${source}/lib/libreadline* $POSTGRES_HOME/local/lib
cp ${source}/include/z* $POSTGRES_HOME/local/include

--Bob

+-----------------------------+------------------------------------+
| Robert E. Bruccoleri, Ph.D. | email: bruc@acm.org                |
| President, Congenomics Inc. | URL:   http://www.congen.com/~bruc |
| P.O. Box 314                | Phone: 609 818 7251                | 
| Pennington, NJ 08534        |                                    |
+-----------------------------+------------------------------------+

Wed, 8 Oct 2003 09:02:56 -0400 (EDT)
"Robert E. Bruccoleri" <bruc@stone.congenomics.com>
Compilation of PostgreSQL on Irix
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Wed, 8 Oct 2003, Robert E. Bruccoleri wrote:

> Dear Devrim,
> 	I have been using Postgres on Irix for over 8 years, and I have only
> used the SGI provided compilers. GCC doesn't work well on Irix. In addition,
> you can build a 64 bit version of PostgreSQL. Here's the script we used for

<snip> (http://archives.postgresql.org/pgsql-hackers/2003-10/msg00422.php)

(Sorry for the late response, I just could find time to try your solution)

No, PostgreSQL 7.4beta4/5 does not still compile on SGI Irix, running on 
rs10000. :( 

I've also tried to compile 7.3.4 but I got some errors,too. I'm not 
familiar to Irix, I'm trying to use my logic on Linux.

I'm pretty sure that I have a problem with GCC.:
=========================
bash-2.05b$ /usr/freeware/bin/gcc -v
Reading specs from /usr/freeware/lib/gcc-lib/mips-sgi-irix6.5/3.2.1/specs
Configured with: ../configure --prefix=/usr/freeware 
- --enable-version-specific-runtime-libs --disable-shared --enable-threads 
- --enable-haifa --disable-c99
Thread model: single
gcc version 3.2.1
=========================
bash-2.05b$ bison --version
GNU Bison version 1.25
========================

(I know the problem with bison, but freeware.sgi.com just provides bison 
1.35, not 1.875)

So, shall we exclude IRIX support from v7.4? :(

Regards,
- -- 
Devrim GUNDUZ
devrim@gunduz.org				devrim.gunduz@linux.org.tr 
			http://www.tdmsoft.com
			http://www.gunduz.org




-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE/npE+tl86P3SPfQ4RAtgdAKCpKan/xGUO2ioD1TDIpS+vOez0fwCeI+a0
WYrNfWB5uB/UUHTZyLWzARE=
=Sjon
-----END PGP SIGNATURE-----


Tue, 28 Oct 2003 17:54:37 +0200 (EET)
Devrim GUNDUZ <devrim@gunduz.org>
Re: Compilation of PostgreSQL on Irix
Dear Devrim,
	You can build the latest release of bison from www.gnu.org
without any trouble under Irix. PostgreSQL 7.4 builds cleanly on Irix,
and so far, it's much faster than 7.3 for the one database I've
tested. --Bob

+-----------------------------+------------------------------------+
| Robert E. Bruccoleri, Ph.D. | email: bruc@acm.org                |
| President, Congenomics Inc. | URL:   http://www.congen.com/~bruc |
| P.O. Box 314                | Phone: 609 818 7251                | 
| Pennington, NJ 08534        |                                    |
+-----------------------------+------------------------------------+

Tue, 28 Oct 2003 11:16:07 -0500 (EST)
"Robert E. Bruccoleri" <bruc@stone.congenomics.com>
Re: Compilation of PostgreSQL on Irix
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Tue, 28 Oct 2003, Robert E. Bruccoleri wrote:

> 	You can build the latest release of bison from www.gnu.org
> without any trouble under Irix.

Is it just bison that creates the problem? 

I'll try on Thursday (it's national holiday in here) and will report to 
you.

Regards,
- --
Devrim GUNDUZ
devrim@gunduz.org				devrim.gunduz@linux.org.tr 
			http://www.tdmsoft.com
			http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE/npwqtl86P3SPfQ4RAnQGAKC5kZRvPnZhW4fe03ypWmQTdZPJfwCfaSpe
UTk70+WJn0fSs9Y8Em+eGeE=
=4/oS
-----END PGP SIGNATURE-----


Tue, 28 Oct 2003 18:41:05 +0200 (EET)
Devrim GUNDUZ <devrim@gunduz.org>
Re: Compilation of PostgreSQL on Irix
On Tue, 2003-10-28 at 11:41, Devrim GUNDUZ wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> 
> Hi,
> 
> On Tue, 28 Oct 2003, Robert E. Bruccoleri wrote:
> 
> > 	You can build the latest release of bison from www.gnu.org
> > without any trouble under Irix.
> 
> Is it just bison that creates the problem? 
>

bison should only be causing troubles if your building from cvs, not
from the beta package...
 
Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


28 Oct 2003 13:08:44 -0500
Robert Treat <xzilla@users.sourceforge.net>
Re: Compilation of PostgreSQL on Irix
Devrim GUNDUZ <devrim@gunduz.org> writes:
> On Tue, 28 Oct 2003, Robert E. Bruccoleri wrote:
>> You can build the latest release of bison from www.gnu.org
>> without any trouble under Irix.

> Is it just bison that creates the problem? 

If you're working from a tarball rather than a CVS pull, you shouldn't
actually need an up-to-date bison to build PG, because the bison output
files are pregenerated for you.  configure will complain that your bison
is too old, but you can ignore that and keep going.

			regards, tom lane

Tue, 28 Oct 2003 14:08:53 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Compilation of PostgreSQL on Irix 