[pgsql-jp: 31636] Re: ｐｏｓｔｇｒｅＳＱＬをクライアントからＴＣＰ／ｉｐ接続するには？

[梶本]

$BKYEDMM(B
$B3aK\$G$9!#$o$6$o$6$I$&$b62=L$G$9!#(B
$B$3$s$J<B83$r$7$F$42sEz$/$@$5$kJ}$,$$$i$C$7$c$k$H$O!&!&!&!#(B
$B!!;d$O!";d$NCN$i$J$$%N%&%O%&$r%"%I%P%$%9$7$F$$$?$@$-$?$/(B
$B$3$N%a!<%j%s%0%j%9%H$K;22C$5$;$F$$$?$@$$$F$$$^$9!#(B
$B$^$?:#8e!";d$,%"%I%P%$%9$G$-$k$b$N$O!"%"%I%P%$%9$7$F$$$1$k(B
$B$H$h$$$H9M$($F$$$^$9!#$N$G!":#8e$b59$7$/$*4j$$$$$?$7$^$9!#(B

> $B$"$HG0$N$?$a!"85!9F~$C$F$$$?(B postgresql $B$N%Q%C%1!<%8$O>C$7$F$^$9(B
> $B$h$M!)(B
$B#p#o#s#t#g#r#e#S#Q#L$NF3F~$O!":#2s$,$O$8$a$F$G$9!#(B
$B0J>e$G$9!#(B
$B!]!]!]!]!]!]!]!]JV?.$O$3$3$^$G!]!]!]!]!]!]!]!]!]!]!]!]!]!]!]!](B
> $BKYED$G$9!#(B
> 
> From: "$B3aK\(B" <kajimoto ＠ www.kt-network.jp>
> Subject: [pgsql-jp: 31619] Re: $B#p#o#s#t#g#r#e#S#Q#L$r%/%i%$%"%s%H$+$i(B
$B#T#C#P(B
> $B!?#i#p@\B3$9$k$K$O!)(B
> Date: 2003/11/27 10:15:19
> 
> > $BFCJL$K(BIP$B#v(B6$B$N ＠ _Dj$r9T$C$F$$$k$o$1$G$O!"$"$j$^$;$s!#(B
> > PostgreSQL$B$O!"(B7.4$B$r%@%&%s%m!<%I$7$F!"%3%s%Q%$%k$7$^$7$?!#(B
> > $B$^$?!"(Blinux $B$O!"(Bredhat 7.0$B$r%$%s%9%H!<%k$7$F$$$^$9!#(B
> > $B!!!!4V0c$($^$7$?!"(Bredhat 9.0$B$G$9!#(B
> > $B>0!"%M%C%H%o!<%/$K$D$$$F$O!"FCJL$J ＠ _Dj$r$7$F$$$^$;$s!#(B
> 
> $B!&(BRedHat Linux 9.0 on VMware
> $B!&FCJL$K(B IPv6 $B$N ＠ _Dj$O9T$C$F$$$^$;$s!#(B
> $B!&!JIaCJ;H$o$J$$$N$G!K%Q%C%1!<%8$N%"%C%W%G!<%H$bA4$/9T$C$F$$$^$;$s!#(B
> $B!&%M%C%H%o!<%/$K$D$$$F$O!"(BIPv4 $B$G8GDj(B IP $B$r?6$C$F$$$^$9!#(B
> 
> $B$3$N$h$&$J4D6-$,$"$C$?$N$G!"(B postgresql-7.4.tar.gz $B$r;}$C$F$-$F(B
> 
>   ./configure --enable-debug
> 
> $B$@$1$N%*%W%7%g%s$G%S%k%I$7$F$_$^$7$?!#(Bconfigure $B$NESCf$G(B
> 
>   ($BN,(B)
> checking for bison... bison -y
> configure: WARNING:
> *** The installed version of Bison is too old.  PostgreSQL needs
> *** Bison version 1.875 or later.
>   ($BN,(B)
>   checking for struct sockaddr_in6... yes
> $B$H$+8@$o$l$^$7$?!#(B
> 
> $B$"$H$O ＠ 5>o$K%S%k%I$G$-$?$_$?$$$J$N$G!"(Bpostgresql.conf $B$G(B
> tcpip_socket = true
> $B$H ＠ _Dj$7$F!"(Bpg_hba.conf $B$K!J3NG'MQ$H$7$F!K(B
> host all all 192.168.0.0 255.255.255.0 trust
> 
> $B9T$rDI2C$7$F5/F0$9$k$H!"(B
> 
> $ pg_ctl start
> postmaster successfully started
> postgres ＠ vm_rh9 ~$ LOG:  could not create IPv6 socket: $B%"%I%l%9%U%!%_(B
$B%j$O%W(B
> $B%m%H(B $B%3%k$K$h$C$F%5%]!<%H$5$l$F$$$^$;$s(B
> LOG:  database system was shut down at 2003-11-27 11:48:23 JST
> LOG:  checkpoint record is at 0/9B0C0C
> LOG:  redo record is at 0/9B0C0C; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction ID: 535; next OID: 17142
> LOG:  database system is ready
> 
> $B$H3aK\$5$s$HF1$8$h$&$KE\$i$l$^$9$,!"(B
> 
> ps ax|grep postg
> 
> $B$G3NG'$9$k$H!"$A$c$s$H%W%m%;%9$, ＠ 8$-$F$$$^$9!#JL$N%^%7%s>e$N(B
> $B!V(Bpsql $B$H$$$&%/%i%$%"%s%H!W$+$i!V(BTCP/IP$B$G!WL5;v@\B3$G$-$^$7$?!#(B
> 
> /proc $BG[2<$"$?$j$N$I$3$+$N%U%!%$%k$K(B use_ipv6_socket $B$_$?$$$J$*$J(B
> $B$8$J$$$,$"$k$+$HC5$7$F$_$^$7$?$,!"$A$i$C$H8+$?8B$j$G$O8+Ev$?$j$^(B
> $B$;$s!#$H$j$"$($:$3$N7Y9p!)$OL5;k$7$F$$$$$s$8$c$J$$$G$7$g$&$+(B:-)
> 
> # configure $B;~$K(B HAVE_IPV6 $B$H$+$r;&$;$P=P$J$/$J$k$N$+$J$!!#(B
> 
> --
> $BKYED(B $BNQ1Q(B <hotta ＠ net-newbie.com> <http://www.net-newbie.com>