Dear Tom Lane.
On Tue, 11 Nov 2003 09:18:48 -0500 Tom Lane <[EMAIL PROTECTED]> wrote:
> Kiyoshi Sawada <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
