$B
PostgreSQL >=V6.1 $B$N$?$a$N$h$/$"$ko$N(B FAQ $B$HJ;$;$F$*FI$_2<$5$$(B
$B:G=*99?7F|(B: Fri Jun 19 13:35:00 BST 1998
$BF|K\8lHG:[email protected]|!'(B 1998$BG/(B06$B7n(B22$BF|(B
$B8=:_$N0];}4IM}$KI,MW$JJQ99$O$"$j$^$9$+!)(B
1.2) libreadline $B$,8+$D$+$i$J$$$H$$$&LdBj$O$J$<5/$3$j$^$9$+!)(B
1.3) [REDHAT] libdl $B$H(B dlfcn.h $B$,8+$D$+$i$J$$$H$$$&LdBj$O$J$<5/$3$j$^$9$+!)(B
1.4) [SLACKWARE 3.1] libdl $B$H(B dlfcn.h $B$,8+$D$+$i$J$$$H$$$&LdBj$O$J$<5/$3$j$^(B
$B$9$+!)(B
1.5) backend $B$N%3%s%Q%$%k$,%$%s%/%k!<%I%U%!%$%k(B dlfcn.h $B$,8+$D$+$i$J$$$H$$$&(B
$B$3$H$G=*$j$^$9!#(B
1.6) GCC $B$,%*%W%7%g%s(B -fpic $B$rL5;k$7$?$H$\$d$-$^$9!#(B
1.7) $BH$O2?(B
$B$G$9$+!)(B
1.14) [DEBIAN] libtermcap $B$O$I$3$K$"$j$^$9$+!)(B
1.15) [REDHAT] RPM $B$G$N(B PostgreSQL $B$O$N4qL/$J?6Iq!#(B
3.8) PostgreSQL $B$,Av$C$F$$$k;~$K%7%9%F%`$r%7%c%C%H%@%&%s$9$k$H!"(B
Linux $B$O%j%V!<%H$N;~$K$$$D$b%G%#%9%/$r(B fsck $B$7$^$9!#(B
3.9) regression $B%F%9%H$NLd$$9g$o$;(B 32 $B$K$H$F$b;~4V$,$+$+$k$N$O$J$<$G$9$+(B?
3.10) $B$"$k(B date/time $B$N1i;;$G!"0J2<$N$h$&$JL/$J4]$a$H$J$k$N$O$J$<$G$9$+!)(B
select '4 hours'::timespan;
returning '3 hours 59 minutes 60 seconds'?
------------------------------------------------------------------------
Section 1: PostgreSQL $B$N%3%s%Q%$%k(B
1.1) src/Makefile.global $B$d(B src/Makefile.custom $B$K$O2?$rJQ99$9$l$P(B
$B$h$$$G$7$g$&$+!"$^$?!"$=$NB>$KI,MW$JJQ99$O$"$j$^$9$+!)(B
makefile$BEy$X$NJQ99$O!"(BMakefile.custom $B$r=q$-=P$9(B customize $B%7%'(B
$B%k%9%/%j%W%H$r(B src $B%G%#%l%/%H%j$GAv$i$;$k$3$H$K$h$j:G$b4JC1$K$G(B
$B$-$^$9!#(B
[$BLuCm(B
customize $B%3%^%s%I$O(B 6.1 $B0J9_$J$/$J$j$^$7$?!#(B
]
$B$=$NB>$K$d$i$J$/$F$O$J$i$J$$JQ99$O!"$b$7(B Flex $B$N%P!<%8%g%s$,$h(B
$B$/CN$i$l$F$$$k%P%0$N$"$k(B 2.5.3 $B$N>l9g$O!"(Bcreateuser $B$,<:GT$9$k(B
$B!JH!K$N$G!"$=$l$rCV$-49$($k$3$H$G$9!#(B
$B$b$7!"(Bmakefile$BEy$rl=j$KJQ99$9$kI,MW(B
$B$,$"$j$^$9!'(B
POSTGRESDIR
USE_TCL $B%*%W%7%g%s$r@8$+$9$J$i$P!"0J2<$NJQ?t$r%;%C%H$9$kI,MW$,(B
$B$"$j$^$9!'(B
TCL_INCDIR=
TCL_LIBDIR=
TCL_LIB=
TK_INCDIR=
TK_LIBDIR=
TK_LIB=
X11_INCDIR=
X11_LIBDIR=
X11_LIB=
$BI.$C$F$=$NB>$KI,MW$JJQ99$r$7$F$b9=$$$^$;$s!#(B
1.2) libreadline $B$,8+$D$+$i$J$$$H$$$&LdBj$O$J$<5/$3$j$^$9$+!)(B
Linux $B%7%9%F%`$O0lHLE*$K%$%s%9%H!<%k:Q$_$N(B GNU readline $B%i%$%V(B
$B%i%j$r4^$s$G$$$^$;$s!#(BGNU readline $B%i%$%V%i%j$r%$%s%9%H!<%k$9(B
$B$k$+!"$^$?$O!"(Bsrc/Makefile.global $B$"$k$$$O(B src/Makefile.custom
$B$G(B readline $B%*%W%7%g%s$r3h@-2=$7$J$$$h$&$K$7$^$7$g$&!#(B
Debian Linux $B$G$O(B(FreeBSD $B$N$h$&$K(B) readline $B$,%$%s%9%H!<%k$5(B
$B$l$FMh$k$3$H$r$3$3$K5-$7$F$*$-$^$9!#(B
1.3) [REDHAT] libdl $B$H(B dlfcn.h $B$,8+$D$+$i$J$$$H$$$&LdBj$O$J$<5/$3$j$^$9$+!)(B
$B$3$N$3$H<+?H$,!"%3%s%Q%$%k$N:G8e$N%U%'!<%:$G(B dlopen() $B$d(B
dlclose() $B$J$I$N$h$&$J4X?t$H%j%s%/$G$-$J$$$3$H$rL@<($7$F$$$^$9!#(B
libdl $B%i%$%V%i%j$O(B $B%f!<%6Ds6!4X?t$H$7$F$C$F$$$^$9!#(B
$B:#$O!"?7$7$$(B ld.so $B$N(B RPM $B%Q%C%1!<%8$,(B RedHat $B$N(B FTP $B%5%$%H$K(B
$B$"$j$^$9!#4JC1$KF~$7$F$_$F2<$5$$!#(B
$BCm0U!*(B $B%i%$%V%i%j$N%$%s%9%H!<%k$N8e$K:F%3%s%Q%$%k$r9T$J$&A0$K!"(B
configure $B$rAv$i$;D>$7$F(B make clean $B$r$7$J$1$l$P$J$i$J$$$G$7$g$&!#(B
$B$3$l$i$N%i%$%V%i%j$r99?7$7$F$$$k$H$-$K%"%/%;%9$9$k%W%m%0%i%`$N(B
$B$?$a$K%7%9%F%`$,Mn$A$?$H8@$&Js9p$,0l$D$"$j$^$7$?(B($B6C$/$3$H$G$O(B
$B$"$j$"$j$^$;$s$,(B)$B!#$7$?$,$C$F!"?7$7$$%i%$%V%i%j$r%$%s%9%H!<%k(B
$B$9$kA0$K%7%9%F%`$r:F5/F0$9$k$N$ONI$$9M$($G!"$J$k$Y$/99?7Cf$OAv(B
$B$i$;$k$b$N$r>/$J$/$7$^$7$g$&!#%7%s%0%k%f!<%6!&%b!<%I$K$J$k$N$,(B
$BNI$$$G$7$g$&!#(B
$B$b$7!"$=$l$rFq$7$$J}K!$G$7$?$$$N$G$"$l$P!"l=j$+$i%i%$%V%i(B
$B%j$H%X%C%@$r$9$+$N$I$A$i$r$7$F$b9=$$$^(B
$B$;$s!#$?$@$78e/$J$/$7$^$7$g$&!#%7%s%0%k%f!<%6!&%b!<%I$K$J$k$N$,(B
$BNI$$$G$7$g$&!#(B
$B:G$b4JC1$J=$@5$O(B ldso.tgz $B$r:G?7$N(B Slackware 3.1 $B$NG[5k$N(B a4
disk $B$+$i$7$F(B make clean $B$r$7$J$1$l$P$J$i$J$$$G$7$g$&!#(B
$B$r$7$^$9!#$b$7!"$7$F(B make clean $B$r$7$J$1$l$P$J$i$J$$$G$7$g$&!#(B
1.5) backend $B$N%3%s%Q%$%k$,%$%s%/%k!<%I%U%!%$%k(B dlfcn.h $B$,8+$D$+$i$J$$$H$$$&$3$H$G=*$j$^$9!#(B
$Bl9g$O!"(B-fPIC $B$,4{DjCM$H$J$j(B
$B$^$9$N$G!"$3$N$3$H$OL5;k$7$F$bBg>fIW$G$9!#(B
$B$3$l$O!"(Bsrc/Makefile.global $B$rJT=8$7!"(BCFLAGS_SL $B$rJQ99$9$k(B
$B$3$H$GD{@5$G$-$^$9!#(B
1.7) $BfIW$G$9!#(BPostgreSQL V6.0 $B$G$O!"%7%9%F%`%X%C%@!<%U%!%$(B
$B%k$K4X$9$k7Y9p!J$3$l$i$b0BA4$KL5;k$G$-$^$9!K0J30$O!"7Y9pL5$7$K(B
$B%3%s%Q%$%k$G$-$k$O$:$G$9!#(B
1.8) [SuSE-Linux 4.2-4.4] curses $B$H(B termcap $B$O$I$3$K$"$j$^$9$+!)(B
SuSE-Linux 4.2 $B$K(B ncurses $B$O$"$j$^$9$,(B curses $B$O$"$j$^$;$s!#(B
4.4 $B$K$ON>J}$"$j$^$9!#(BSuSE-Linux $B$N(B termcap $B%i%$%V%i%j$b$^$?(B
/usr/lib $B$NCf$G$O$J$/(B /usr/lib/termcap $B$NCf$K$"$j$^$9!#(B
PostgreSQL (up to V6.0)
-----------------------
src/Makefile.custom $B$NCf$G(B CURSES_LIB $B$NCM$K(B -lncurses $B$r@_Dj(B
$B$7$^$9!J$"$k$$$O%+%9%?%^%$%:%9%/%j%W%H$rDL$7$F9T$J$$$^$9!K!#(B
$BH2<$5$$!#(B
1.11) a.out $B%7%9%F%`$G$O(B PostgreSQL $B$r$I$N$h$&$K%3%s%Q%$%k$7$^$9$+!)(B
$B:G=i$K!"(Bdld $B%i%$%V%i%j$r%$%s%9%H!<%k$7$J$/$F$O$J$j$^$;$s!#$3$l(B
$B$O!"(BSunsite:
LINUX/libs/dld.3.2.7.tar.gz
(ftp://sunsite.unc.edu/pub/Linux/libs/dld.3.2.7.tar.gz)
$B$+$iF~$9$K$O!"C1=c$K(B src/mk/port/postgres.mk.linux $B$rJT=8$7$F!"(B
$B$=$N%U%!%$%k$N=*$j$N(B
# YACC = bison -y
$B$r(B
YACC = bison -y
$B$KJQ99$7$^$9!#(B
1.13) src/Makefile.global $B$NCf$G(B X11_LIB $B$N(B libsocket $B$H(B libnsl $B$X$N;2>H$O2?$G$9$+!)(B
$B$3$l$O(B 1.08 $B$G$N!J(BSun Solaris $B$KFCM-$N!KLdBj$G$7$?!#(B1.09 $B$H(B
6.0$B$G$OD>$C$F$$$^$9!#(B
1.14) [DEBIAN] libtermcap $B$O$I$3$K$"$j$^$9$+!)(B
Debian Linux $B$K$O(B termcap $B%i%$%V%i%j$OIU$$$F$3$J$/$F!"!J$=$NBe(B
$B$o$j$K(B terminfo $B$r;H$&!K(Bncurses $B$r;H$$$^$9!#(BDebian $B$O(B
$B!J(BSuSE-Linux $B$H$O0c$$(B --- $B$N4v$D$+(B
$B$N%W%m%0%i%`$N$h$&$K%a%b%j$r05Gw$7!"$=$N7k2LDL>oA`:n$G$O5/$-$J(B
$B$$%(%i!<$K=*$j$^$9!#$h$j>.$5$J4pK\%=%U%H$G$b$"$j$^$9$,!"$3$N(B
$B$h$&$JEY9g$K$^$G$O%O!<%I%&%'%"$r05Gw$7$^$;$s$N$G!"(BDOS/Windows
$B$N2<$G$O$3$N$h$&$JLdBj$K9g$&$3$H$OL5$$$+$bCN$l$^$;$s!#(B
$B$h$j>\:Y$J>pJs$O!'(B
http://www.bitwizard.nl/sig11
$B$K$"$j$^$9!#(B
$B$3$N(B Sig11 FAQ $B$K$h$k$H!"(BCyrix $B%W%m%;%C%5>e$G$N(B Redhad 5.0 gcc
$B$rAv$i$;$k;~$NFCJL$JLdBj$,$"$k$h$&$G$9!#>\:Y$O>e5-$N(B URL $B$r8fMw(B
$B2<$5$$!#(B
1.18) MkLinux $B$G(B 6.1.1 $B$r%$%s%9%H!<%k$G$-$^$9$+!)(B
$B@P0fC#IW$5$s(B $B$,(B MkLinux DR2.1 update2 $B0J9_(B
$B$G9T$J$$$^$7$?!#>.$5$J%Q%C%A$O!'(B
ftp://ftp.sra.co.jp/pub/cmd/postgres/6.1.1/mklinux.patch.gz
$B$+$iF~$N?M!9(B
$B$N%;%C%H%"%C%W$G$O@5>o$KF0$$$F$$$k$3$H$,CN$i$l$F$$$^$9!#$H$j$"$((B
$B$:$O!"$3$NLdBj$K$D$$$FJs9p$r9T$J$&A0$K!"(Bgmake $B$r:G?7HG$K%"%C%W%0(B
$B%l!<%I$7$F$_$F$/$@$5$$!#(B
1.20) 486 $B$d(B Pentium $B%W%m%;%C%5MQ$N:GE,2=$O$I$N$h$&$K$9$k$N$G$9$+!)(B
$B%G%U%)%k%H$N%3%s%Q%$%i!&%U%i%0$G$O(B 486 $B$d(B Pentium $B%W%m%;%C%5!<(B
$B$N$?$a$N:GE,2=$O9T$J$$$^$;$s!#$3$N$h$&$J:GE,2=$r2C$($k$K$O!"(B
Makefile.custom $B$rJT=8$7$F!'(B
CFLAGS+= -m486
$B$^$?$O!"(B($B$^$@!"$"$^$jAv$i$;$F$$$k?M$N$$$J$$?7$7$$%3%s%Q%$%i$G$O(B)
CFLAGS+= -mpentium
$B$^$?$O(B
CFLAGS+= -mpentiumpro
$B$r2C$($^$9!#(B
1.21) $B;~4V$r0u:~$7$h$&$H$9$k$H$I$&$7$FJQ$J7k2L$K$J$k$N$G$9$+(B($BNc$($P!"(B regression $B%F%9%H$N(B 'timespan)$B!)(B
$B;~4V$O!"(B'5 hours' $B$N$+$o$j$K(B '4 hours 59 mins 60.00 secs' $B$N$h$&$K(B
$B$J$j$^$9!#(B
$B$3$NLdBj$O(B Redhat 5.0 $B$K4^$^$l$F$/$k(B glibc2 $B$G$NLdBj$G$9!#(Bglibc $B$r(B
$B:G?7$N(B v5.0/hurricane $B$N(B RedHat $B%P!<%8%g%s$K%"%C%W%G!<%H$7$F2<$5$$!#(B
glibc-2.0.7 $B$h$jA0$N$b$N$OLdBj$,$h$/$"$k$h$&$G$9!#(B
1.22) 6.3.2 $B$r%3%s%Q%$%k$7$?;~$K(B libpq $B$N$?$a$N6&M-%i%$%V%i%j$,$G$-$J$$$N$O$J$<$G$9$+!)(B
v6.3.2 $B$N$?$a$N(B Linux $B%3%s%U%#%0%l!<%7%g%s$O=*$k@#A0$GN%C&$r$*$3$7(B
$B$F$^$7$?!#(Bftp://postgresql.org/pub/patches/ $B$K(B linux_elf $B%Q%C%A$r(B
$B4^$`4v$D$+$N=$@5$,>e$,$C$F$$$^$9$N$G8+$F2<$5$$!#(B
1.23) $B%3%s%Q%$%k$,(B F_BOOLIN, F_BOOLOUT $B$*$h$S(B F_BYTEAIN $B$,L$Dj5A$G$"$k$H$N%a%C%;!<%8$G<:GT$9$k$N$O$J$<$G$9$+!)(B
$Be$G$OD>$C(B
$B$F$$$^$9!#(B
3.2) postmaster $B$rAv$i$;$?8e!"%7%9%F%`$,(B 'Bad system call(Core dumped)' $B$H8@$$$^$9!#(B
$B$3$l$O!"6&M-%a%b%j$N%5%]!<%H$rAH$_9~$^$J$$$G%+!<%M%k$N%3%s%Q%$%k(B
$B$r$7$F$7$^$C$?$3$H$r<($7$^$9!#(BLinux $B%+!<%M%k$K$3$N5!G=$rAH$_9~$s(B
$B$G%3%s%Q%$%k$7D>$9I,MW$,$"$j$^$9!#(B
3.3) Postmaster $B$rAv$i$;$h$&$H$9$k;~!"$9I,MW$,$"$k$G$7$g$&!#(B
3.6) $B$I$&$7$F!"(Bpsql $B$,A0$r$=$N%U%!(B
$B%$%k$N=*$j$K0l9T2C$($^$9!#$=$&$7$F!"(B
/sbin/ldconfig -v
$B$rAv$i$;$^$9!#(B
$B$"$k$$$O!"(B($B$b$7!"(Broot $B$K$J$l$J$1$l$P(B)$B!"(BLD_LIBRARY_PATH $B4D6-JQ(B
$B?t$r;H$C$F$b9=$$$^$;$s!#(B
LD_LIBRARY_PATH $B4D6-JQ?t$O!"6&M-%i%$%V%i%j$,A\$5$l$k%Q%9$r%3%m(B
$B%s$G6h@Z$C$?$?%j%9%H$G$9!#$3$N%j%9%H$O!"(Bldconfig $B$K$h$j;XDj$5(B
$B$l$?%i%$%V%i%j$NA0$KA\$5$l$^$9!#(B
$B$3$N;XDj$O!"(Bbash $B$G$O(B:
export LD_LIBRARY_PATH='PathToPGSQL'/lib
$B$N$h$&$K$7!"$^$?!"(Btcsh $B$r;H$C$F$$$k>l9g$O(B:
setenv LD_LIBRARY_PATH 'PathToPGSQL'/lib
$B$H$7$F!"(B'PathToPGSQL' $B$rE,@Z$J(B PostgreSQL $B$N:G>eIt$N%Q%9$KCV$-(B
$B49$($^$9!#(B
ldd $B%3%^%s%I$OF0E*7k9g$N$N4qL/$J?6Iq!#(B
$BA4$/F0:n$7$J$$;~0J30$K$I$s$JC{8u$H$J$k$+$O$o$+$j$^$;$s$,!"F0E*(B
$B%m!<%@$,(B libpq $B%i%$%V%i%j$N@5$7$$%P!<%8%g%s$r%m!<%I$9$k$3$H$K(B
$BCm0U$rJ'$&I,MW$,$"$k$3$H$@$1$OL@$i$+$G$9!#$b$7!"8E$$%P!<%8%g%s(B
$B$,%i%$%V%i%j%Q%9(B($BNc$($P!"(B/usr/lib)$B$N$I$3$+$K$"$k$H!"%m!<%I$9$k(B
$B$D$b$j$N?7$7$$%P!<%8%g%s$N$+$o$j$K%m!<%I$5$l$F$7$^$&$+$b$7$l$^(B
$B$;$s!#8E$$%P!<%8%g%s$,%Q%9$K$J$$$N$r3N$+$a$k$H$H$b$K!"(BQ3.6 $B$N(B
$B%i%$%V%i%j$N%m!<%I$K$D$$$F$N>\:Y$r8+$F2<$5$$!#(B
3.8) PostgreSQL $B$,Av$C$F$$$k;~$K%7%9%F%`$r%7%c%C%H%@%&%s$9$k$H!"(B
Linux $B$O%j%V!<%H$N;~$K$$$D$b%G%#%9%/$r(B fsck $B$7$^$9!#(B
$B$3$N;vNc$,4v$D$+Js9p$5$l$F$$$^$9$,!"$=$l$O(B INSTALL $B%I%-%e%a%s(B
$B%H$NDs0F$K=>$C$F(B /etc/inittab $B$+$i(B PostgreSQL $B$rAv$i$;$?7k2L$N(B
$B$h$&$K8+pJs$K$h$k$H(B):
1. regress.sh $B$NCf$G
$B