Dear Tom Lane.
On Tue, 11 Nov 2003 09:18:48 -0500 Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Kiyoshi Sawada <sawa@nagoya2.jrc.or.jp> writes:
> > 2. Regression Failur stats ..... FAILED .
> > 3. Not running stats buffer process and stats collector process.
>
> So why not? Try looking in the postmaster log for errors related to
> stats collector startup. (pstat is irrelevant, btw.)
>
There are 'could not bind socket for statistics collector' in the postmaster log.
postmaster log
----------------------------
LOG: could not bind socket for statistics collector: Cannot assign requested address
LOG: database system was shut down at 2003-11-12 08:56:59 JST
LOG: checkpoint record is at 0/D743BCC
LOG: redo record is at 0/D743BCC; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 25593; next OID: 684071
LOG: database system is ready
----------------------------
Networks and logs are shown below...
----------------------------
# netstat -a | grep 5432 *.5432 *.* 0 0 65536 0 LISTEN *.5432
*.* 0 0 65536 0 LISTEN *.5432 *.* 0 0 65536 0
LISTEN
e1135ea8 stream-ord e1853918 00000000 /tmp/.s.PGSQL.5432
# cat /etc/inet/hosts
127.0.0.1 localhost mebius
127.0.0.1 mebius localhost
172.20.12.109 mebius
# ifconfig -a
lo0: flags=1000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4> mtu 8232 index 1 inet 127.0.0.1 netmask ff000000
pcni0: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 3 inet 172.20.12.109 netmask ffff0000
broadcast172.20.255.255 ether 0:90:99:51:70:53
#cat pg_hba.conf
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all trust
# IPv4-style local connections:
host all all 127.0.0.1 255.255.255.255 trust
# IPv6-style local connections:
host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff tru
st
----------------------------
--
Kiyoshi Sawada
