Thread: Compilation of PostgreSQL on Irix

Compilation of PostgreSQL on Irix

From
"Robert E. Bruccoleri"
Date:
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        |                                    |
+-----------------------------+------------------------------------+


Re: Compilation of PostgreSQL on Irix

From
Devrim GUNDUZ
Date:
-----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-----



Re: Compilation of PostgreSQL on Irix

From
"Robert E. Bruccoleri"
Date:
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        |                                    |
+-----------------------------+------------------------------------+


Re: Compilation of PostgreSQL on Irix

From
Devrim GUNDUZ
Date:
-----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-----



Re: Compilation of PostgreSQL on Irix

From
Robert Treat
Date:
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



Re: Compilation of PostgreSQL on Irix

From
Tom Lane
Date:
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