diff options
Diffstat (limited to 'doc/FAQ_Linux')
| -rw-r--r-- | doc/FAQ_Linux | 37 |
1 files changed, 31 insertions, 6 deletions
diff --git a/doc/FAQ_Linux b/doc/FAQ_Linux index 313187ddeaa..e420e269444 100644 --- a/doc/FAQ_Linux +++ b/doc/FAQ_Linux @@ -4,7 +4,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL >= V6.1 Linux Specific TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ ======================================================= -last updated: Thu Dec 15 12:05:00 GMT 1997 +last updated: Wed Feb 18 13:00:00 GMT 1997 current maintainer: Andrew C.R. Martin (martin@biochem.ucl.ac.uk) original author: Andrew C.R. Martin (martin@biochem.ucl.ac.uk) @@ -12,10 +12,8 @@ original author: Andrew C.R. Martin (martin@biochem.ucl.ac.uk) Changes in this version (* = modified, + = new, - = removed): -*1.3) [REDHAT] Why do I get problems with missing libdl and dlfcn.h? -*1.4) [SLACKWARE 3.1] Why do I get problems with missing libdl and dlfcn.h? -+1.19) Why does make exit or crash? - ++1.20) How can I optimise for 486 or pentium processors ++3.10) Why do I get funny rounding results in some date/time arithmetic... This file is divided approximately as follows: 1.*) Installing PostgreSQL @@ -55,6 +53,7 @@ Questions answered: 1.17) When compiling postgres, gcc reports signal 11 and aborts. 1.18) Can I install 6.1.1 under MkLinux? 1.19) Why does make exit or crash? +1.20) How can I optimise for 486 or pentium processors 2.1) The linker fails to find libX11 when compiling pgtclsh 3.1) I get an error reporting _fUnKy_POSTPORT_sTuFf_ undefined when running scripts like createuser @@ -77,6 +76,10 @@ Questions answered: 3.8) When PostgreSQL is running when the system is shutdown, Linux always fsck's the disk when rebooted. 3.9) Why does Query 32 in the regression tests take so long? +3.10) Why do I get funny rounding results in some date/time arithmetic, + such as + select '4 hours'::timespan; + returning '3 hours 59 minutes 60 seconds'? ---------------------------------------------------------------------- Section 1: Compiling PostgreSQL @@ -298,7 +301,7 @@ Section 1: Compiling PostgreSQL Some versions of SuSE provide only ncurses, so you may need to force use of ncurses rather than curses by changing - -lcurses to -lncurses. + -lcurses to -lncurses. (Reported true for SuSE 5.1) 1.9) Why do I get problems with ld.so? @@ -430,6 +433,19 @@ Section 1: Compiling PostgreSQL In short, try upgrading gmake to the latest version you can find before reporting this as a problem +1.20) How can I optimise for 486 or pentium processors + + The default compiler flags perform no optimisation for 486 + or Pentium processors. To add such optimisation, edit + Makefile.custom and add: + + CFLAGS+= -m486 + + or (for the new compilers that most people are not yet running) + + CFLAGS+= -mpentium + or + CFLAGS+= -mpentiumpro ---------------------------------------------------------------------- Section 2: Compiling accessory programs @@ -617,6 +633,15 @@ exit 0 then type: sh ./perquery < bench.out > & bench.out.perquery + + +3.10) Why do I get funny rounding results in some date/time arithmetic, + such as + select '4 hours'::timespan; + returning '3 hours 59 minutes 60 seconds'? + + You are running the new glibc2 libraries and have a version earlier than + 2.0.7. It is a math rounding problem in the library. Upgrade your library. ---------------------------------------------------------------------------- Dr. Andrew C.R. Martin University College London EMAIL: (Work) martin@biochem.ucl.ac.uk (Home) andrew@stagleys.demon.co.uk |