Thread: regress failed tests.. SERIOUS?

PLEASE NOTE: I'm brand new to PostgreSQL as of today. I've just moved from
MySQL because it's not stable on NetBSD/Alpha. I don't know enough about
pgsql to see if these failed test would make it unstable for production.

i start the server like this:

$ postmaster -D /usr/pkg/pgsql/data > /var/pgsql/logfile 2>&1 &

I've seen many messages on the console when doing the regression
tests. However, none of the warnings, or debug, or status messages went to
the logfile as it should have. logfile is currently still empty.


NetBSD/DEC-Alpha (ELF) 1.5.1_ALPHA
PostgreSQL 7.0.3

$ uname -a
NetBSD ns01 1.5.1_ALPHA NetBSD 1.5.1_ALPHA (ALPHA-$Revision: 1.127.2.2
$) #2: Fri Dec 15 16:45:58
 CST 2000     tom@ns01:/usr/src/sys/arch/alpha/compile/ns01 alpha

$ grep failed regress.out
int8 .. failed
float8 .. failed
numerology .. failed
timestamp .. failed
oidjoins .. failed
type_sanity .. failed
opr_sanity .. failed
horology .. failed
rules .. failed

int8 and float8 seemed OK. int8 just had numbers with '-' or '+' signs
instead of the '<' or '>' around numbers. float8 reported same error in a
different format.

the rest of the test failed pretty bad. see the attachment.

"Thomas T. Thai" <tom@minnesota.com> writes:
> PLEASE NOTE: I'm brand new to PostgreSQL as of today. I've just moved from
> MySQL because it's not stable on NetBSD/Alpha. I don't know enough about
> pgsql to see if these failed test would make it unstable for production.

Postgres 7.0.* will not work very well on Alpha unless you apply Ryan
Kirkpatrick's patch set (I forget the URL offhand, but dig around in our
archives and you'll find it).  7.1 should be a lot better.  If you'd
like to help out testing 7.1, please grab current sources from the CVS
server, or grab a snapshot tarball dated tomorrow or later.

            regards, tom lane