Building PgSQL 7.4.2 on SGI Irix 6.19

note: gmake check had a few out-of-order errors like this:
*** 1732,1739 ****
| 6 | 6 | six |
| 7 | 7 | seven |
| 8 | 8 | eight |
- | | | null |
| | 0 | zero |
(13 rows)
--- 1732,1739 ----
| 6 | 6 | six |
| 7 | 7 | seven |
| 8 | 8 | eight |
| | 0 | zero |
+ | | | null |
(13 rows)

I'm not sure how serious a problem this is.
My configure&etc patches are at the end of this message.

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

Installing PostGreSQL 7.4.2 on SGI Irix 6.19

Summary:
(install dependencies)
cp *.patch postgresql-7.4.2
cd postgresql-7.4.2
patch -p1 < _pg_config_programs_m4.patch
autoconf
export PATH=/usr/freeware/bin:$PATH
./configure --with-whatever
gmake
gmake check

Patches: Copy the patches you want (READ THE DESCRIPTIONS!)
to the postgres source directory, install them and run autoconf
to generate a new configure script:

patch -p1 < patchname.patch
autoconf

1) The configure.in patch just squelches a bunch of warnings
in the config.log. It's not necessary unless you think
you'll run into errors you'll need to debug.

2) The config/programs.m4 patch adds -lcurses to the command line.
If you don't use it, you'll get undefined symbol errors
trying to compile with readline support.

3) The template/irix5 patch adds the commands to turn on threading.
It is untested! Don't expect your server to work if you use this.

Generic problems: Using zsh 3.0.8, configure will often quit
at a random point in the middle of running, claiming it received
a sigint. This is probably a bug in zsh. Try opening a new shell
and re-running configure from there.

Readline support: SGI Freeware's readline 4.3 package installs
the libraries to the wrong directory. You will need to move
the N32 (mips-3) readline libs from /usr/lib to /usr/lib32
or else the linker won't detect -lreadline. Use the file command
to see what ABI the libraries are using.

You will also need the programs.m4 patch to add -lcurses to the
gcc command line, or else you will get errors like this:
189218:./conftest: rld: Error: unresolvable symbol
in /usr/lib32/libreadline.so.4: tgetent

Java support: You'll need to install Java and ant and ant's dependencies,
which is a difficult and sparsely documented task in itself. SGI has
a java inst package available for download, or you can grab the latest
version from Sun. As for ant's dependencies, I just grabbed everything
on Apache's website since the docs say ant needs just about all of them,
sorted it all into one directory except for a few packages that were
obviously standalone and unnecessary, moved this mess into java2
so I don't have to deal with setting classpath to two dozen different
directories, set all the java PACKAGE_HOME variables to $JAVA_HOME,
and prayed. It survives configure, but is otherwise not tested.

Notes on java support:
1) (important): Make sure that ant.jar is the full one from
the ant package, not a stripped-down version from one of its
dependencies which depends upon ant. You need the real thing,
otherwise you will get java.lang.InstantiationException:
org.apache.tools.ant.Main

2) Ant takes upwards of a minute just to load itself.
As far as I can tell, this is normal behaviour.
configure may /seem/ hung on ant, but just be patient.

Perl support: Irix has two versions of Perl. SGI uses perl 5.0
in the main tree, but the newer 5.6.1 is available from freeware.
Perl 5.0's libs do not define EXTERN_C, causing gmake to break
in src/pl/plperl/plperl.c. 5.6.1 has EXTERN_C defined, but 5.6.1's
Dynaloader.a breaks on "./ldtmpa01Ns3/DynaLoader.a(DynaLoader.o).B":
Error: Invalid format revision (WHIRL::0.31:) for intermediate compiler file

Temporary Solution 1 (using perl 5.0):
1: export CFLAGS="-DEXTERN_C=extern $CFLAGS"

Temporary solution 2 (using perl 5.6.1) (theoretical, haven't tried):
1: Rebuild perl 5.6.1 from source, without -IPA
2: Copy over the Dynaloader.a
3: Put /usr/freeware/bin before /usr/sbin in path
and export it before running configure. Easiest way,
in zsh: export PATH=/usr/freeware/bin:$PATH
4: Add to your configure command:
--with-libraries=/usr/freeware/lib/perl5/5.6.1/irix-n32/CORE/libperl.so
--with-includes=/usr/freeware/lib/perl5/5.6.1/CORE

Python support: As long as the freeware python packages do not install
shared libraries, you cannot get python support without compiling
python yourself. I haven't tried this, so I'm not sure if it will work.

GNU Tar support:

Irix uses an old, b0rked version of tar which breaks on long pathnames.
If you have GNU Tar installed, you need to put /usr/freeware/bin
at the front of your path before running configure. I don't know
when or where Postgres uses tar, but it's in the Makefile.global file,
so it's worth mentioning.

XML Support:

First, install libxml2 from freeware. Then in contrib/xml/Makefile:
CFLAGS := -I/usr/freeware/include/libxml2 -L/usr/freeware/lib32
gmake, su, gmake install.

where "test" is the name of your database:
psql -f ~pgsql/share/contrib/pgxml_dom.sql test

PostGIS Support (as of .8.1):

Find and install Geos and Proj from source. Find and untar PostGIS source
in contrib. In Makefile, set USE_PROJ=1 and USE_GEOS=1 if they aren't already.

*important!* manually run, since the makefile doesn't catch this:
gcc -c postgis_geos_wrapper.cpp -I/usr/local/include/geos

gmake, su, gmake install.

where "test" is the name of your database:
~pgsql/bin/createlang plpgsql test
psql -f ~pgsql/share/contrib/postgis.sql -d test
psql -f ~pgsql/share/contrib/spatial_ref_sys.sql -d test

PostGIS JDBC:

Add your postgres installation's share/java directory to $CLASSPATH,
or add the files therein to an existing $CLASSPATH directory.
Find your postgres's share/java/postgis.jar file and unzip it.
cd contrib/postgis/jdbc. Edit Makefile, change $CLASSPATH
to the location of the unzipped jar file plus the current directory:
On my system, this is: CLASSPATH = /usr/java2/lib:.

in jdbc/examples/TestServer.java, find these lines:
((org.postgresql.Connection)conn).addDataType("geometry","org.postgis.PGgeometry");
((org.postgresql.Connection)conn).addDataType("box3d","org.postgis.PGbox3d");
and replace them with:
((org.postgresql.PGConnection)conn).addDataType("geometry","org.postgis.PGgeometry");
((org.postgresql.PGConnection)conn).addDataType("box3d","org.postgis.PGbox3d");

then find these lines:
String dbname = "tb";
String dbuser = "dblasby";
String dbpass = "";
String dbhost = "ox";
String dbport = "5555";
And replace this with the correct information to your server.
Make sure that you have created a test database and a user for this,
that you are using the correct port (usually 5432, not 5555),
that postmaster is running with -i to allow TCP connections,
and that your host-based authentication (data/pg_hba.conf) is set
to allow connections from your system.

gmake, gmake test, gmake jtest

You'll have to install postgis-jdbc manually by copying it to your $CLASSPATH:
cd org, su, cp -R postgis /usr/java2/lib/org

-------------
Appendix 1: dmt's configure script (It compiles, ship it):
./configure --with-ssl=/usr/freeware/lib/openssl --enable-thread-safety \
--enable-integer-datetimes --enable-debug --enable-depend --enable-cassert \
--with-tcl --with-perl --with-java \
--with-tclconfig=/usr/freeware/lib --with-tkconfig=/usr/freeware/lib

-------------
Appendix 2: dmt's patches to PostgreSQL 7.4.2

--- a/config/programs.m4 Tue Mar 16 08:04:54 2004
+++ b/config/programs.m4 Thu Mar 11 11:11:02 2004
@@ -87,9 +87,9 @@
pgac_save_LIBS=$LIBS
LIBS="${pgac_rllib}${pgac_lib} $LIBS"
AC_TRY_LINK_FUNC([readline], [[
- # NetBSD and OpenBSD have a broken linker that does not
+ # Irix, NetBSD, and OpenBSD have a broken linker that does not
# recognize dependent libraries
- case $host_os in netbsd* | openbsd* )
+ case $host_os in netbsd* | openbsd* | irix* )
case $pgac_lib in
*curses*) ;;
*) pgac_lib=" -lcurses" ;;
--- a/configure.in Thu Mar 11 08:42:19 2004
+++ b/configure.in Thu Mar 18 09:04:46 2004
@@ -651,11 +651,21 @@
then
AC_CHECK_LIB(bsd, main)
fi
+# Irix has nsl, socket, gen, and sun in its libc, but also
+# keeps separate libs around for backwords compatibility.
+# Using them creates warnings in config.log. This test quiets that.
+# See also: http://freeware.sgi.com/howto.html
+# Also consider changing the portname, since I'm doing this on irix 6.19
+if test "$PORTNAME" != "irix5"
+then
+AC_CHECK_LIB(nsl, main)
+AC_CHECK_LIB(socket, main)
+AC_CHECK_LIB(gen, main)
+fi
+
AC_CHECK_LIB(util, setproctitle)
AC_CHECK_LIB(m, main)
AC_CHECK_LIB(dl, main)
-AC_CHECK_LIB(nsl, main)
-AC_CHECK_LIB(socket, main)
AC_CHECK_LIB(ipc, main)
AC_CHECK_LIB(IPC, main)
AC_CHECK_LIB(lc, main)
@@ -663,7 +673,6 @@
AC_CHECK_LIB(ld, main)
AC_CHECK_LIB(compat, main)
AC_CHECK_LIB(BSD, main)
-AC_CHECK_LIB(gen, main)
AC_CHECK_LIB(PW, main)
AC_CHECK_LIB(resolv, main)
AC_SEARCH_LIBS(getopt_long, [getopt gnugetopt])
--- a/src/template/irix5 Thu Mar 18 09:06:08 2004
+++ b/src/template/irix5 Tue Mar 16 10:49:22 2004
@@ -0,0 +1,3 @@
+THREAD_SUPPORT=yes
+NEED_REENTRANT_FUNCS=yes
+THREAD_LIBS="-lpthread"

-------------
Appendix 3: dmt's patches to PostGIS 0.8.1
--- a/jdbc/examples/TestServer.java Fri Apr 19 08:14:17 2002
+++ b/jdbc/examples/TestServer.java Thu Mar 25 10:55:00 2004
@@ -32,8 +32,8 @@
String url = "jdbc:postgresql://" + dbhost + ":" + dbport + "/" + dbname;
conn = DriverManager.getConnection(url, dbuser, dbpass);
System.out.println("Adding geometric type entries...");
- ((org.postgresql.Connection)conn).addDataType("geometry","org.postgis.PGgeometry");
- ((org.postgresql.Connection)conn).addDataType("box3d","org.postgis.PGbox3d");
+ ((org.postgresql.PGConnection)conn).addDataType("geometry","org.postgis.PGgeometry");
+ ((org.postgresql.PGConnection)conn).addDataType("box3d","org.postgis.PGbox3d");
Statement s = conn.createStatement();
System.out.println("Creating table with geometric types...");
//table might not yet exist