[pgsql-jp: 31300] Re: Postgresスタートについて

[Miyao]

$B5\Hx$G$9!#(B
$B3'$5$s$N$4;XF3$r85$K!"2<5-$N:n6H$r9T$C$?$H$3$m!"(BLOG:  database system is
ready
$B$G;_$^$C$F$7$^$$%-!<%\!<%I$+$i(Bctrl $B!\(B C$B$r2!2<$7CfCG$9$k$H%@%&%s$7$F$7$^(B
$B$$!"(B
$B;2$C$F$$$^$9!#(B
$B$4;XF32<$5$$!#(B
$B$A$J$_$K:#;29M$K$7$F$$$k%5%$%H$O2<5-%"%I%l%9$G$9!#(B
http://www.fsinet.or.jp/~akifumi/installmemo.html
$B!V%Z!<%8$NCfDx2a$.$K5-:\$5$l$F$$$^$9!#!W(B
[root ＠ web root]# su postgres
[postgres ＠ web root]# cd /usr/local/pgsql
[postgres ＠ web pgsql]# initdb
[postgres ＠ web pgsql]$ /usr/local/pgsql/bin/postmaster -D
/home/postgres/data -o -i
LOG:  database system was shut down at 2003-10-24 05:20:31 JST
LOG:  checkpoint record is at 0/8018BC
LOG:  redo record is at 0/8018BC; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 480; next oid: 16976
LOG:  database system is ready
ctrl $B!\(B C $B2!2<(B
LOG:  fast shutdown request
LOG:  shutting down
LOG:  database system is shut down
[postgres ＠ web miyao]$

$B4_ED$5$s$N%l%9(B
> > [postgres ＠ web bin]$ /usr/local/pgsql/bin/postmaster -D  
> > /home/postgres/ -o -i
> -D /home/postgres/data
> $B$G$O$J$$$G$9$+!)(B
$B4_ED$5$s$N8@$o$l$?0z?t$rIU$1$J$$%9%?!<%H$O!"$^$@;n$7$F$$$J$$$N$G$9$,(B
$B0z?t$O2<5-$NMM$KIU$1$J$$J}$,NI$$$N$G$9$+!)(B
/usr/local/pgsql/bin/postmaster -D /home/postgres/data

$B8eF#$5$s$N%l%9(B
> > FATAL:  data directory /home/postgres/ has group or world access; 
> > permissions should be u=rwx (0700)
> $B$3$l$rJ|CV$7$F$$$k$N$O$J$<$G$7$g$&$+!)(B
$B0JA0$N>e5-$K;w$?%(%i!<%a%C%;;~$O2<5-$G$7$?!#(B~/data$B$NJ}$O$4;XE&DL$j(B
$B%Q!<%_%e!<%7%g%s$r(B700$B$K$J$*$7$^$7$?!#(B
$B!JA02s!K(B
FATAL:  data directory /home/postgres/data has group or world access;
permission s should be u=rwx (0700)
$B:#2s$O(BPostgres$B$N%[!<%`%G%#%l%/%H%j!<$=$N$b$N$r(B700$B$KD>$7$J$5$$$H$$$&%((B
$B%i!<$G$7$?!#(B
$B!J:#2s!K(B
FATAL:  data directory /home/postgres/ has group or world access; 
permissions should be u=rwx (0700)
$B$7$+$7!"(BPostgres$B$N%[!<%`%G%#%l%/%H%j!<$=$N$b$N$r(B700$B$KD>$7$?>l9g%M%C%H%V(B
$B%i%&%6$+$i(B
PHP$B$r;H$$%"%/%;%9$7$?;~$KFI$_9~$a$J$$$N$G$O!)$H5?Ld$K;W$$Ej9F$7$F$_$^$7(B
$B$?!#(B
$BJ|CV$O$7$F$$$^$;$s!#(B

$BBg>l$5$s$N%l%9(B
> $B%G!<%?$rCV$/%G%#%l%/%H%j!"%Q!<%F%#%7%g%s!"%I%i%$%V$r(B
> $BJ,$1$?$$$C$F$3$H$b>l9g$K$h$C$F$O$"$j$^$9$7!"(B
> $BM}M3$,$"$C$F!V(B/home/postgres/data$B!W$K$7$?$$$s$@$H;W$$$^$9$,(B
> $B!t2?$+$NK\$K$=$&=q$$$F$"$C$?$H$$$&OC$J$i(B
> $B!t$=$l$O(BLinux$B$N(BRPM$B$G%$%s%9%H!<%kA0Ds$NK\$@$+$i$G$7$g$&(B
> $B!t%=!<%9$+$iF~$l$F$kK\$@$H!";XDj$G$-$k$H$O=q$$$F$"$k$1$I(B
> $B!tB?J,!V(B/home/postgres/data$B!W$r;H$&$h$&$K$O=q$$$F$J$$(B
$BKM$O!">e5-$N%[!<%`%Z!<%8$r;29M$K:#2s9=C[$7$F$$$-$^$7$?!#(B
$B0JA09=C[$7$?;~$O#V#i#n#e#L#i#n#u#x(B2.0$B$K(Bpostgresql-7_0_3_tar.gz$B$r%$%s%9(B
$B%H!<%k(B
$B$7$?;~$K$O!":#2s$HF1MM$K$+$J$j6l ＠ o$7$?$N$G$9$,!":G=*E*$K$O%$%s%9%H!<%k$,(B
$B=PMh(B
$BL5;v;H$($kMM$K$J$C$F:n6H%m%0$r;29M;qNA$K:n ＠ .$9$k;v$,=PMh$^$7$?!#(B
$B$7$+$7!":#2s$O%P!<%8%g%s$,0c$&0Y!"E,MQ$OFq$7$$$@$m$&$H;W$$(Bweb$B$+$i(B
$B;29M;qNA$rC5$7%$%s%9%H!<%k$7$^$7$?!#(B
$B0JA0$O#d#a#t#a%G%#%l%/%H%j!<$O%G%U%)%k%H$G%$%s%9%H!<%k$7$?$N$G$9$,!":#2s(B
$B;29M$K$7$?(B
$B#H#P$K$O!"(B/home/postgres/$B$K(Bdata$B%G%#%l%/%H%j$r:n$k$h$&$J$3$H$r5-:\$5$l$F(B
$B$$$?$N$G(B
$B$F$C$-$jKM$O%P!<%8%g%s$K$h$C$F0[$J$k$s$@$H;W$C$F$$$^$7$?!#(B

$B59$7$/$*4j$$$7$^$9!#(B

$B!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y(B

   $B!!!!#N#a#m#e(B $B!!!!!!!!!!!!!!(B $B5\Hx!!>!L&!J(BK$B#a#t#u#m#i(B,Miyao$B!K(B
   $B!!!!#E!]#m(Ba$B#i#l!!!!!!(B $B!!(B      miyao ＠ m4.dion.ne.jp

$B!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z!y!z(B