1 =======================================================
2 Frequently Asked Questions (FAQ) for PostgreSQL
4 TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ
5 =======================================================
6 last updated: $Date: 2006/12/06 15:45:31 $
8 current maintainer: Luis Amigo (lamigo@atc.unican.es)
9 original author: Luis Amigo (lamigo@atc.unican.es)
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.
18 ----------------------------------------------------------------------
19 Section 1: Installing PostgreSQL
20 ----------------------------------------------------------------------
22 1.1) What do I need to install PostgreSQL on IRIX?
24 PostgreSQL has been reported to run successfully on MIPS r8000, r10000(both
25 ip25 and ip27) and r12000(ip35) processors, running IRIX 6.5.5m, 6.5.12,
26 6.5.13, and 6.5.26 with MIPSPro compilers version 7.30, 7.3.1.2m, 7.3, and
29 Aside from the PostgreSQL source distribution, you will need GNU make
30 (SGI's make will not do), and the MIPSPro full ANSI C compiler.
32 There are problems trying to build with GCC. It is a known gcc bug
33 (not fixed as of version 3.0) related to using functions that return
34 certain kinds of structures. This bug affects functions like
35 inet_ntoa, inet_lnaof, inet_netof, inet_makeaddr and semctl. It is
36 supposed to be fixed by forcing code to link those functions with
37 libgcc, but this has not been tested yet.
39 It is known that version 7.4.1m of the MIPSPro compiler generates
40 incorrect code. (Symptom is "invalid primary checkpoint record"
41 when trying to start the database.) Version 7.4.4m is OK; the status
42 of intermediate versions is uncertain.
45 1.2) Anything special about the build/install procedure?
47 There may be a compilation problem like the following:
49 cc-1020 cc: ERROR File = pqcomm.c, Line = 427
50 The identifier "TCP_NODELAY" is undefined.
52 if (setsockopt(port->sock, IPPROTO_TCP, TCP_NODELAY,
54 Some versions include TCP definitions in <sys/xti.h>, so it is necessary to
55 add #include <sys/xti.h> in src/backend/libpq/pqcomm.c and in
56 src/interfaces/libpq/fe-connect.c.
59 1.3) OK, it seemed to build and install, but the regression test fails.
61 There are several "expected failures" due to differences between your platform
62 and the regression test reference platform used by the PostgreSQL group. All
63 of these should be compensated for by the regression test comparison
64 mechanism, with the possible exception of some low-order-digit differences in
65 the geometry tests (depending on which FPU are you using).
67 Any other error is cause for suspicion.