The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration Guide by The PostgreSQL Global Development Group Paperback (6"x9"), 274 pages ISBN 9781906966072 RRP £9.95 ($14.95) Sales of this book support the PostgreSQL project! Get a printed copy>>>

PostgreSQL 9.0 Reference Manual Volume 3 Buy the book here! >>> only $14.95

1.8.4 IRIX

PostgreSQL has been reported to run successfully on MIPS r8000, r10000 (both ip25 and ip27) and r12000(ip35) processors, running IRIX 6.5.5m, 6.5.12, 6.5.13, and 6.5.26 with MIPSPro compilers version 7.30, 7.3.1.2m, 7.3, and 7.4.4m.

You will need the MIPSPro full ANSI C compiler. There are problems trying to build with GCC. It is a known GCC bug (not fixed as of version 3.0) related to using functions that return certain kinds of structures. This bug affects functions like inet_ntoa, inet_lnaof, inet_netof, inet_makeaddr, and semctl. It is supposed to be fixed by forcing code to link those functions with libgcc, but this has not been tested yet.

It is known that version 7.4.1m of the MIPSPro compiler generates incorrect code. The symptom is “invalid primary checkpoint record” when trying to start the database.) Version 7.4.4m is OK; the status of intermediate versions is uncertain.

There may be a compilation problem like the following:

cc-1020 cc: ERROR File = pqcomm.c, Line = 427
  The identifier "TCP_NODELAY" is undefined.

                if (setsockopt(port->sock, IPPROTO_TCP, 
  TCP_NODELAY,

Some versions include TCP definitions in ‘sys/xti.h’, so it is necessary to add #include <sys/xti.h> in ‘src/backend/libpq/pqcomm.c’ and in ‘src/interfaces/libpq/fe-connect.c’. If you encounter this, please let us know so we can develop a proper fix.

In the regression tests, there might be some low-order-digit differences in the geometry tests, depending on which FPU are you using. Any other error is cause for suspicion.