Failed to build on Solaris.

Summary
1. Checking for pstat... no
2. Regression Failur  stats ..... FAILED .
3. Not running stats buffer process and stats collector process.

------------------------------------------------
Environments
 SunOS 5.8 Generic_108528-15 sun4m sparc
 SunOS 5.8 Generic_108529-23 i86pc i386 i86pc
Both sparc and i386
 PostgreSQL 7.4 RC2
 gcc (GCC) 3.3.2
 autoconf (GNU Autoconf) 2.57 
 bison (GNU Bison) 1.875
 GNU Make 3.80
------------------------------------------------

(1) checking for pstat... no
$ ./configure --enable-integer-datetimes \
              --without-readline --with-openssl
-----------------------
  : : : :
checking sys/pstat.h usability... no
checking sys/pstat.h presence... no
  : : : :
checking for pstat... no
  : : : :
-----------------------

(2) Regression Failur  stats ..... FAILED
$ make check
     : : : :
     sequence             ... ok
     polymorphism         ... ok
     stats                ... FAILED
============== shutting down postmaster  ==============
=======================
 1 of 93 tests failed.
=======================

(3) Not running stats buffer process and stats collector process.
$ pg_ctl start -D /usr/local/pgsql/data
$ ps -ef | grep postmaster
postgres 15912 15899  0 11:32:59 pts/2    0:00 grep postmaster
postgres 15864     1  0 11:17:03 pts/1    0:00 /usr/local/pgsql/bin/postmaster
$

--
Kiyoshi Sawada


Tue, 11 Nov 2003 15:27:45 +0900
Kiyoshi Sawada <sawa@nagoya2.jrc.or.jp>
7.4RC2 regression failur and not running stats collector process on
	Solaris
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.)

			regards, tom lane

Tue, 11 Nov 2003 09:18:48 -0500
Tom Lane <tgl@sss.pgh.pa.us>
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@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 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




Wed, 12 Nov 2003 10:00:22 +0900
Kiyoshi Sawada <sawa@nagoya2.jrc.or.jp>
Re: 7.4RC2 regression failur and not running stats collector process
	on Solaris
Kiyoshi Sawada <sawa@nagoya2.jrc.or.jp> writes:
> On Tue, 11 Nov 2003 09:18:48 -0500  Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> So why not?  Try looking in the postmaster log for errors related to
>> stats collector startup.  (pstat is irrelevant, btw.)

> LOG:  could not bind socket for statistics collector: Cannot assign requested address

Hmm ... that's sure the problem, but what can we do about it?  ISTM that
any non-broken system ought to be able to resolve "localhost".  Actually
it's worse than that: your system resolved "localhost" and then refused
to bind to any of the IP addresses it had resolved.  Look at the logic
in pgstat_init() in src/backend/postmaster/pgstat.c.  I think this
suggests a misconfiguration in your system ... but if you can suggest a
more robust way of setting up that connection, I'm all ears ...

			regards, tom lane

Tue, 11 Nov 2003 22:35:18 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: 7.4RC2 regression failur and not running stats collector process
	on Solaris