[pgsql-jp: 37940] Re: PostgreSQL のマイナーアップグレードについて

[Hiroshi Saito]

$B$5$$$H$&$G$9!#(B

> $B0$It$H?=$7$^$9!#:rG/$O(B PostgreSQL 8.1.4 $B$N%$%s%9%H!<%k$G$*@$OC$K$J$j$^$7$?!#(B
> 
> $B!!8=:_(B PostgreSQL $B$O(B
> 
> $B!!!!!!(BWindows XP SP2 + PostgreSQL 8.1.4
> 
> $B$G1?MQ$7$F$*$j$^$9!#3X9;$N>pJs%G!<%?%Y!<%9$G$9$N$G(B PostgreSQL 8.2 $B$X$N(B
> $B%"%C%W%0%l!<%I$OG/EYBX$o$j$N;~4|$r9M$($F$*$j$^$9!#$?$@!"%^%$%J!<%"%C%W%0(B
> $B%l!<%I$@$1$O$7$F$*$/$Y$-$@$H;W$$$^$9$N$G!"(BWindows $BHG$NF|K\8lHG$,%"%C%W(B
> $B$5$l$?$i!"(B8.1.6 $B$X%"%C%W%0%l!<%I$9$k$D$b$j$G$*$j$^$9!#(B

$B$O$$!"(B8.2.1$B$OAaB.=P$7$?$G$9$,!"(B8.1.6$B$N$[$&$O$=$N:n ＠ .$7$F$$$?%^%7%s$N%G%#%9%/(B
$B$,Jk$l$K$*K4$/$J$j$K$J$j$^$7$F!&!&4D6-$H$H$b$K:F:n ＠ .Cf$J$N$G$7$?!#(B
$B$H$$$&!"$^$3$H$K?=$7Lu$J$$M}M3$GCY$l$F$$$^$9!#(Bm(__)m
$B$=$l$G!"$3$N:]$K(B8.1.5$B$N$H$-$N<~JU$N%i%$%V%i%j4X78$b(B8.2.1$B$"$?$j$K9g$o$;$i$l$?(B
$B$i3Z$@$J$!$H9M$($F$$$^$9!#$3$3$G$[$H$s$I$OLdBj$J$$$HG'<1$7$F$$$k$N$G$9$,!"<B(B
$B$O!"(BPostGIS$B$^$o$j$r$I$&$9$k$+$GG:$s$G$$$^$9!&!&Ev;~$^$@(BDebug$B$7$-$l$J$$$H$-$K(B
$B8E$$%P!<%8%g%s$G3NG'Ds6!$7$F$$$?$N$G$9$,!"(BPostGIS$BK\2H$H:G6a860x$rFM$-;_$a(B
$B$?$N$G!"$=$NBP>]%P!<%8%g%s$rAH$_9~$_$?$$$H;W$C$F$$$?$j$7$^$9!#$3$N$H$-!"8_49(B
$B ＠ -$NLdBj$,$"$j$^$7$F!";H$C$F$$$k%f!<%6$OC1=c$K%"%C%W%0%l!<%I$G$-$J$$$H$$$&(B
$B$3$H$K$J$C$F$7$^$$$^$9!&!&(B

$B$^$@!"<~JU$N4D6-$, ＠ 0$C$F$$$J$$$N$G!"$=$l$+$i:FEY==J,$K8!F$$7$?$$$H;W$C$F$$$^$9!#(B
$B$$$^!"$^$@@0M}$,$D$$$F$$$^$;$s!#(B

> 
> $B!!$H$3$m$G!"0l$D$o$+$i$J$$$3$H$,$"$j$^$9$N$G65$($F$/$@$5$$!#$=$l$O!"%^%$%J!<(B
> $B%"%C%W%0%l!<%I$9$k$?$a$K$O%@%&%s%m!<%I$7$?%U%!%$%k$N$&$A(B
> 
> $B!!!!!!(Bupgrade.bat
> 
> $B$r<B9T$9$l$P$h$$$3$H$O$o$+$k$N$G$9$,!"<B9T8e%"%C%W%0%l!<%I$9$k$N$O(B
> PostgreSQL $B$NK\BN$@$1$J$N$+!"(BpgAdmin$B-7(B $B$d(BODBC$B%I%i%$%PEy$N%D!<%k(B
> $B$=$NB>$b:G?7HG$K%"%C%W%0%l!<%I$9$k$N$+$H$$$&$3$H$G$9!#(B

upgrade.bat$B$O$=$l$i4{B8$N%$%s%9%H!<%k$5$l$F$$$?%b%8%e!<%k4X78$r$9$Y$F(B
$B>e=q$-$9$k$3$H$K$J$j$^$9!#(B
$B$b$7!"$R$H$D$N9=@.$@$1$rF~$lBX$($?$$$H$$$&$H$-$K$O!"(Bmsi$B$r5/F0$7$FA*Br9=@.$N(B
$BJQ99$+$iBP>]$r2r=|$7$F!":FEY(Bmsi$B5/F0$H$FA*Br$9$k$3$H$G99?72DG=$G$9!#(B
$B$?$@!"%G!<%?%Y!<%99=@.$OJQ99$G$^$;$s$N$G$4Cm0U$,I,MW$G$9$M!#(B

> 
> $B!!FC$K5$$K$J$k$N$O(BODBC$B%I%i%$%P$G!"2?Bf$+$N%Q%=%3%s$O(BODBC$B%I%i%$%P(B
> $B$@$1%$%s%9%H!<%k$7$F$"$j$^$9$N$G!"%P%C%/%(%s%I$rF0$+$9%5!<%P!<$N(BODBC
> $B%I%i%$%P$,%"%C%W%0%l!<%I$9$k$J$i$P!"B>$N%Q%=%3%s$N(BODBC$B%I%i%$%P$b%"%C%W(B
> $B%0%l!<%I$7$?$$$H;W$$$^$9!#8=:_(B ODBC $B%I%i%$%P$N%P!<%8%g%s$O(B
> 
> $B!!!!!!(Bpsqlodbc08020004
> 
> $B$G$9!#$^$?!"$b$7(BODBC$B%I%i%$%P$b%"%C%W%0%l!<%I$9$k$J$i$P!"(B
> $B8E$$%P!<%8%g%s$r%"%s%$%s%9%H!<%k$7$F$+$i%"%C%W%0%l!<%I(B
> $B$7$J$/$F$h$$$+$b?4G[$G$9!#(B
> 
> $B!!$4;XF3J}!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B

$BI,$:$7$b$=$l$r4+$a$k$o$1$G$O$"$j$^$;$s$,!"(B($B$1$C$3$&;d$bI]$,$j$J$N$G!"(B
$B$"$k4D6-$GF0:n$7$F$$$?$b$N$rL5M}$KJQ$($k$H$$$&$3$H$O4pK\E*$KJQ$($?(B
$B$j$7$J$$$[$&$G$9$,(B)$B%Q%C%1!<%8C10L$KF0:n3NG'$r$7$F$$$^$9$N$G!"F~$l;R(B
$B$K$J$k$h$&$J%P!<%8%g%s%Q%?!<%s$N>l9g$K$O$^$?JL$NCm0U$,$R$D$h$&$K$J$k(B
$B$+$b$7$l$^$;$s!#(B