|
| 1 | +======================================================= |
| 2 | +Frequently Asked Questions (FAQ) for PostgreSQL 7.2 |
| 3 | +IRIX Specific |
| 4 | +TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ |
| 5 | +======================================================= |
| 6 | +last updated: $Date: 2001/12/03 19:33:35 $ |
| 7 | + |
| 8 | +current maintainer: Luis Amigo (lamigo@atc.unican.es) |
| 9 | +original author: Luis Amigo (lamigo@atc.unican.es) |
| 10 | + |
| 11 | + |
| 12 | +Questions covered here: |
| 13 | +1.1)What do I need to install PostgreSQL on IRIX? |
| 14 | +1.2)Anything special about the build/install procedure? |
| 15 | +1.3)OK, it seemed to build and install, but the regression test fails. |
| 16 | + |
| 17 | + |
| 18 | +---------------------------------------------------------------------- |
| 19 | +Section 1: Installing PostgreSQL |
| 20 | +---------------------------------------------------------------------- |
| 21 | + |
| 22 | +1.1)What do I need to install PostgreSQL on IRIX? |
| 23 | + |
| 24 | +PostgreSQL 7.2 has been run on MIPS r8000, r10000(both ip25 and ip27) |
| 25 | +and r12000(ip35) processors, running IRIX 6.5.5m, 6.5.12 and 6.5.13 with |
| 26 | +MIPSPro compilers version 7.30, 7.3.1.2m and 7.3. |
| 27 | + |
| 28 | +Aside from the PostgreSQL source distribution, you will need GNU make |
| 29 | +(SGI's make will not do), and MIPSPro full ANSI C compiler. |
| 30 | + |
| 31 | +Until now there are problems trying to install with GNU's gcc, it is a known |
| 32 | +gcc bug (not fixed at current date, version 3.0) using functions that return |
| 33 | +some kind of structures. This bug affects functions like inet_ntoa, |
| 34 | +inet_lnaof, inet_netof, inet_makeaddr and semctl. It is supposed to be fixed |
| 35 | +by forcing code to link those functions with libgcc, but this has not been |
| 36 | +tested yet. |
| 37 | + |
| 38 | + |
| 39 | +1.2)Anything special about the build/install procedure? |
| 40 | + |
| 41 | +In order to compile with cc you will need to: |
| 42 | + |
| 43 | +configure with-CC=cc |
| 44 | + |
| 45 | +Or you may edit postgres.../src/templates/irix5 |
| 46 | + |
| 47 | +including something like: |
| 48 | + |
| 49 | +CC=cc |
| 50 | +CFLAGS='-O2' |
| 51 | +LDFLAGS='-O2' |
| 52 | + |
| 53 | +It is a good place to improve performance on postgresql, because here you |
| 54 | +may use all MIPSPro power generating specific objects, see man cc. |
| 55 | + |
| 56 | +Other known problem is include location, it may be different from some |
| 57 | +compiler installations to others, if you are getting something like: |
| 58 | + |
| 59 | +cc-1020 cc: ERROR File = pqcomm.c, Line = 427 |
| 60 | + The identifier "TCP_NODELAY" is undefined. |
| 61 | + |
| 62 | + if (setsockopt(port->sock, IPPROTO_TCP, TCP_NODELAY, |
| 63 | + |
| 64 | +Some versions include TCP definitions in <sys/xti.h>, so it is necessary to |
| 65 | +add #include <sys/xti.h> in /src/backend/libpq/pqcomm.c and in |
| 66 | +src/interfaces/libpq/fe-connect.c |
| 67 | + |
| 68 | + |
| 69 | +1.3)OK, it seemed to build and install, but the regression test fails. |
| 70 | + |
| 71 | +There are several "expected failures" due to differences between your platform |
| 72 | +and the regression test reference platform used by the PostgreSQL group. All |
| 73 | +of these should be compensated for by the regression test comparison |
| 74 | +mechanism, with the possible exception of some low-order-digit differences in |
| 75 | +the geometry tests (depending on which FPU are you using) or order differences |
| 76 | +between zero and NULL in join tests(depending on compiler version). |
| 77 | + |
| 78 | +Any other error is cause for suspicion. |