Postgresql Version 7.4.2
Slackware 9.1
kernel 2.4.26

I did:

../configure
make
make check

Here is the regression.diffs file:

*** ./expected/stats.out Fri Oct 31 19:18:20 2003
--- ./results/stats.out Wed Apr 21 09:41:57 2004
***************
*** 62,68 ****
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column? | ?column? | ?column?
----------+----------+----------+----------
! t | t | t | t
(1 row)

SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks +
cl.relpages,
--- 62,68 ----
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column? | ?column? | ?column?
----------+----------+----------+----------
! f | f | f | f
(1 row)

SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks +
cl.relpages,
***************
*** 71,77 ****
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column?
----------+----------
! t | t
(1 row)

-- clean up
--- 71,77 ----
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column?
----------+----------
! f | f
(1 row)

-- clean up

================================================== ====================


I also did:

make install
# and make a database and start the postmaster then
make installcheck

and got the same sort of results.

If you need anymore information let me know.


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

"Mike Quinn" <mquinn (AT) co (DOT) merced.ca.us> writes:
The stats collector isn't starting, but you're not showing any evidence
to suggest why. Try looking in the postmaster log file for related
error messages.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

I found my problem. My iptables setup was not allowing UDP communication
from source 127.0.0.1 and some high port to destination 127.0.0.1 and
the same high port. Once I allowed that communication the "test stats"
was ok. I ran a diff on the postmaster log file from an "ok" run and a
"failed" run and the only difference was the date/time, so there was no
indication there of this type of problem there.

Thanks,
Mike Quinn


The stats collector isn't starting, but you're not showing any
evidence
to suggest why. Try looking in the postmaster log file for related
error messages.

regards, tom lane


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster