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

[Miyao]

$B5\Hx$G$9!#(B
$B$4LBOG$r$*3]$1$7$F$$$^$9!#(B

> $B$+$J$j:$$C$F$k$h$&$G$7$?$N$G!"%a%C%;!<%8$N0ULu$b4^$a$F(B
> $B?&>l$H<+Bp$+$i2?DL$+%a!<%k$r=q$$$F$-$?$D$b$j$G$9$,(B
> $B$I$&$b!"%(%i!<$NFbMF$rM}2r$7$J$$J}$K;W$($F$-$?!D(B
$BKM$O1Q8l$,$I$&$b6l<j$G!"%(%i!<%a%C%;!<%8$,1Q8l$GI=<($5$l$k$H(B
$B>/$7$7$+FI$a$:3'MM$K$4LBOG$r$*3]$1$7$F$$$k;v$r?=$7Lu$J$/;W$C$F$*$j$^$9!#(B
$B1Q8l$,=PMh$J$$$N$G$"$l$P!"#L#i#n#u#x$J$s$+?($k$J$H8@$o$l$k$+$b$7$F$^$;$s(B
$B$,(B
$B<RFb$G(BSAMBA$B$d(BDB$B$r9=C[$9$k$K$O!"$I$&$7$F$bI,MW$J$N$G4X$o$C$F$$$^$9!#(B
Postgres$B$N;H$$J}$K$D$$$F$O!"0JA03X$s$@;v$,$"$k$N$G!"4JC1$J#D#B$J$i(B
$B$"$kDxEY:n$l$k$N$G$9$,!"4N?4$N%=%U%H$,F0$+$J$$;v$K$O$I$&$7$h$&$b$J$$$N(B
$B$G!"(B
$B$3$N#M#L$KEj9F$7$F$$$^$9!#(B
$BKhF|!"?&>l$G%$%s%9%H!<%k$KF,$rDK$a!"$=$m$=$mF0$$$F$/$l$J$$$+$J!<$H(B
$B;W$C$F$$$k$H$3$m$G$9!#(B

> >$B!v(B[postgres ＠ web postgres]$ Lock file 
> >"/home/postgres/data/postmaster.pid" already exists.
> $B!V(B/postmaster.pid" already exists.$B!W$J$N$G!"(B/home/postgres/data/$B0J2<$K(B
> $B$3$l$^$G$NF0$+$=$&$H$7$F$?;~$N(Bpid$B%U%!%$%k$N;D3<$,;D$C$F$k$h$&$G$9!#(B
> ctrl$B!\(BC$B$"$?$j$G;_$a$?;~$K!"$3$l$,;D$C$?$j$7$J$$$+$OJ,$+$j$^$;$s$,(B
> $B$=$N>l9g$O(Bps$B$G(Bpostmaster$B$,F0$$$F$J$$$N$r3NG'$7$F$+$i(B
> $B$3$l$r:o=|$7$F$/$@$5$$(B
> $B$G!":G=i$N%a!<%k$+$i!V(B/home/postgres/$B!W0J2<$K(B
> $B%G!<%?CV$->l$r;XDj$7$?$$$h$&$J$N$G!";D3<$r:o=|$7$?$i(B
> /usr/local/pgsql/bin/postmaster -D /home/postgres/data -o -i &
> $B$H$7$?$i!"$b$&F0$/$s$8$c$J$$$G$9$+!)(B
> $B8+$?46$8$G$O!"(B
> $B!V(B/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data 
> >logfile 2>&1 &$B!W(B
> $B$GF0$$$F$k$h$&$G$9$N$G!#(B
$B:#$^$@1~MQ$G$-$k<BNO$,L5$/8@$o$l$?$H$*$j$K$7$+%$%s%9%H!<%k$G$-$^$;$s!#(B
$B:#8e$bJY6/$r$7$F!"%9%-%k$r>e$2$F$$$-$?$$$H;W$C$F$$$^$9!#(B
$B8@$o$l$?$H$*$j%W%m%;%9$r3NG'$75/F0$7$?$H$3$m!"#1EY$K#3$D$b5/F0$5$l$F$7$^(B
$B$$$^$9!#(B
$B$I$&$7$F!"$3$&$$$&;v$K$J$k$N$G$9$+!)(B
[postgres ＠ yahdoweb postgres]$ ps
  PID TTY          TIME CMD
  958 pts/0    00:00:00 bash
 1044 pts/0    00:00:00 ps
[postgres ＠ yahdoweb postgres]$ /usr/local/pgsql/bin/postmaster -D
/home/postgres/data -o -i &
[1] 1045
LOG:  database system was shut down at 2003-10-26 10:56:21 JST
LOG:  checkpoint record is at 0/801B7C
LOG:  redo record is at 0/801B7C; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 480; next oid: 16976
LOG:  database system is ready
$B;_$^$C$F$7$^$$!"#E#n#t#e#r$r2!2<(B
[postgres ＠ yahdoweb postgres]$ ps
  PID TTY          TIME CMD
  958 pts/0    00:00:00 bash
 1045 pts/0    00:00:00 postmaster
 1046 pts/0    00:00:00 postmaster
 1048 pts/0    00:00:00 postmaster
 1049 pts/0    00:00:00 ps
[postgres ＠ yahdoweb postgres]$ more /home/postgres/data/postmaster.opts
/usr/local/pgsql/bin/postmaster '-D' '/home/postgres/data' '-o' '-i'

$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