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

[梶本]

$B3aK\$G$9!#<+8J%l%9$G$9!#(B
$B#s#e#t#oMM$N%"%I%P%$%9$H!"KYEDMM$N%"%I%P%$%9$G(B
$B0l1~!"#a#c#c#e#s#s$+$i<+J,$N:n ＠ .$7$?%F!<%V%k$,(B
$B;2>H$G$-$^$7$?!#(B
$B!!$"$j$,$H$&$4$6$$$^$7$?!#(B

$ LOG:  could not create IPv6 socket: Address family not supported by
protocol
LOG:  database system was shut down at 2003-11-27 13:43:57 JST
LOG:  checkpoint record is at 0/66827C8
LOG:  redo record is at 0/66827C8; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 18488; next OID: 429565
LOG:  database system is ready


> 
> $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$+(B
$B$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%_(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>
> 
>