Re: [PORTS] Building PgSQL 7.4.2 on SGI Irix 6.19

I have made your configure-related changes for Irix, and renamed the
port from irix5 to irix. Patch attached.

For your other comments, would you please send a new version or diff
against FAQ_IRIX. I am unsure how much of the current content to
change.

Thanks.

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

David Turover wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073