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

[Miyao]

$B5\Hx$G$9!#(B
> $B;29M$K$7$?$=$N(BWeb$B$K=q$+$l$F$$$k<+F05/F0%9%/%j%W%H$K$O(B
> $B!V(Bsu - postgres -c "/usr/local/pgsql/bin/postmaster -D 
> /home/postgres/data -o -i &"$B!W(B
> $B$H!":G8e$K!V(B&$B!W$,=q$+$l$F$^$9$M!)(B
> $B0UL#$,J,$+$j$^$9$+!)!d!V(B&$B!W(B
$B!V!u!W$N0UL#$OJ,$+$j$^$;$s!#$^$@$^$@L$=O<T$J$N$GJ,$+$i$J$$;v$,(B
$BBt;3$"$j!"$4LBOG$r$*$+$1$7$F$$$k$3$H$r?=$7Lu$J$/;W$C$F$$$k$H$3$m$G$9!#(B


>   ./configure
>   gmake
>   su
>   gmake install
>   adduser postgres
>   mkdir /usr/local/pgsql/data
>   chown postgres /usr/local/pgsql/data
>   su - postgres
>   /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
>   /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data 
> >logfile 2>&1 & <-$B$3$3$N:G8e$K$b!V(B&$B!W(B
>   /usr/local/pgsql/bin/createdb test
>   /usr/local/pgsql/bin/psql test
$B>e5-$r;29M$K2<5-$N:n6H$r9T$$$^$7$?$,!"#2$D6&F0$$$F$/$l$^$;$s$G$7$?!#(B

[postgres ＠ web postgres]$ /usr/local/pgsql/bin/initdb -D
/usr/local/pgsql/data
Success. You can now start the database server using:

    /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
or
    /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile
start
[postgres ＠ web postgres]$ /usr/local/pgsql/bin/postmaster -D
/usr/local/pgsql/data >logfile 2>&1 &
[1] 1585
[postgres ＠ web postgres]$ /usr/local/pgsql/bin/postmaster -D
/home/postgres/data -o -i &
[2] 1586
[1]   Exit 1                  /usr/local/pgsql/bin/postmaster -D
/usr/local/pgsql/data >lo
gfile 2>&1
$B;_$^$C$F$7$^$C$?$N$G!"$3$3$G(Bctrl $B!\(B C $B2!2<(B
$B!v(B[postgres ＠ web postgres]$ Lock file
"/home/postgres/data/postmaster.pid" already exists.
$B!v(BIs another postmaster (pid 932) running in "/home/postgres/data"?
$B!v(B[2]+  Exit 1                  /usr/local/pgsql/bin/postmaster -D
/home/postgres/data -o -i
$B9TF,!v0u(B3$B9T$O<+F0$G=P$F$-$F$7$^$$$^$9!#(B

$B%3%^%s%I$+$i2<5-$N$h$&$K$7$?$i$$$$$N$G$9$+!)(B
[postgres ＠ web postgres]$ /usr/local/pgsql/bin/postmaster -D
/usr/local/pgsql/data
[postgres ＠ web postgres]$ /usr/local/pgsql/bin/pg_ctl -D
/usr/local/pgsql/data -l logfile start

$B$4;XF3$h$m$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