Re: 7.4RC2 regression failur and not running stats collector process on Solaris

Dear Tom Lane.

On Tue, 11 Nov 2003 09:18:48 -0500 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Kiyoshi Sawada <sawa(at)nagoya2(dot)jrc(dot)or(dot)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 broadcast 172.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