PostgreSQL Regression Test

With earlier help dealing with System V semaphore and shared memory
commands,
I have now been able to compile and link (with a few warnings detailed
below).

The regression test is failing however. Output from “initdb.log” is below:

Running with noclean mode on. Mistakes will not be cleaned up.
This database system will be initialized with username “dba”.
This user will own all the data files and must also own the server process.

Creating directory /postgresql-7.1.3/src/test/regress/./tmp_check/data
Creating directory /postgresql-7.1.3/src/test/regress/./tmp_check/data/base
Creating directory
/postgresql-7.1.3/src/test/regress/./tmp_check/data/global
Creating directory
/postgresql-7.1.3/src/test/regress/./tmp_check/data/pg_xlog
Creating template1 database in
/postgresql-7.1.3/src/test/regress/./tmp_check/data/base/1

Process 68522027 (postgres) terminated SIGBUS code=3 fltno=11 ip=b031c742
ref=40100004
sed: couldn’t write 86 items to {standard output}: Broken pipe
Bus error (core dumped)

initdb failed.
Data directory /postgresql-7.1.3/src/test/regress/./tmp_check/data will not
be removed at user’s request.
(end initdb.log)

Note that the shell I used is QNX’s default. I know the faq for the QNX4
port said to
avoid it at all means, so I also used bash. I got the exact same log file,
excepting the line
concerning ‘sed’ which was absent.

NEWBIE ALERT
I am new to unix/linux/qnx having spent most of my time in firmware.

For any interested, below are the few compiler warnings I still have, plus a
log of ‘make check’
which shows a ‘sed’ command which may be one of my problems.

Any suggestions, pointers, references would be appreciated.

thanks,
aaron



Compiler Warnings:
pqcomm.c:168: warning: StreamDoUnlink' defined but not used s_lock.c:134: warning: passing arg 1 of sem_trywait’ discards qualifiers
from pointer
target type
/usr/ntox86/bin/ld: Warning: size of symbol _res' changed from 512 to 442 in /x86/lib /libsocket.so pgc.c:1244: warning: label find_rule’ defined but not used
pgc.c:3091: warning: yy_flex_realloc' defined but not used lex.plpgsql_yy.c:987: warning: label find_rule’ defined but not used
lex.plpgsql_yy.c:2263: warning: `plpgsql_yy_flex_realloc’ defined but not
used
(some redundant warnings deleted)

Here’s a partial log of make check:
bash-2.04$ make check
make -C doc all
make[1]: Entering directory /postgresql-7.1.3/doc' make[1]: Nothing to be done for all’.
[… etc …]
All of PostgreSQL successfully made. Ready to install.
make -C src/test check
make[1]: Entering directory /postgresql-7.1.3/src/test' make -C regress check make[2]: Entering directory /postgresql-7.1.3/src/test/regress’
sed -e ‘s,@bindir@,/usr/local/pgsql/bin,g’
-e ‘s,@libdir@,/usr/local/pgsql/lib,g’
-e ‘s,@datadir@,/usr/local/pgsql/share,g’
-e ‘s/@VERSION@/7.1.3/g’
-e ‘s/@host_tuple@/x86-pc-nto-qnx/g’
-e ‘s,@GMAKE@,make,g’
-e ‘s/@enable_shared@/yes/g’
-e ‘s/@GCC@/yes/g’
pg_regress.sh >pg_regress
chmod a+x pg_regress
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I…/…/…/s
rc/interfa
ces/libpq -I…/…/…/src/include -c regress.c -o regress.o
gcc -shared -o regress.so regress.o
sed -e ‘s,@abs_srcdir@,/postgresql-7.1.3/src/test/regress,g’ -e
‘s,@abs_builddir@,/pos
tgresql-7.1.3/src/test/regress,g’ -e ‘s/@DLSUFFIX@/.so/g’ input/copy.source

sql/copy.
sql

sed -e ‘s,@abs_srcdir@,/postgresql-7.1.3/src/test/regress,g’ -e
‘s,@abs_builddir@,/pos
tgresql-7.1.3/src/test/regress,g’ -e ‘s/@DLSUFFIX@/.so/g’
input/create_function_1.sour
ce >sql/create_function_1.sql
sed -e ‘s,@abs_srcdir@,/postgresql-7.1.3/src/test/regress,g’ -e
‘s,@abs_builddir@,/pos
tgresql-7.1.3/src/test/regress,g’ -e ‘s/@DLSUFFIX@/.so/g’
input/create_function_2.sour
ce >sql/create_function_2.sql
sed -e ‘s,@abs_srcdir@,/postgresql-7.1.3/src/test/regress,g’ -e
‘s,@abs_builddir@,/pos
tgresql-7.1.3/src/test/regress,g’ -e ‘s/@DLSUFFIX@/.so/g’ input/misc.source

sql/misc.
sql

sed -e ‘s,@abs_srcdir@,/postgresql-7.1.3/src/test/regress,g’ -e
‘s,@abs_builddir@,/pos
tgresql-7.1.3/src/test/regress,g’ -e ‘s/@DLSUFFIX@/.so/g’
input/constraints.source >sq
l/constraints.sql
sed -e ‘s,@abs_srcdir@,/postgresql-7.1.3/src/test/regress,g’ -e
‘s,@abs_builddir@,/pos
tgresql-7.1.3/src/test/regress,g’ -e ‘s/@DLSUFFIX@/.so/g’ output/copy.source

expected
/copy.out

sed -e ‘s,@abs_srcdir@,/postgresql-7.1.3/src/test/regress,g’ -e
‘s,@abs_builddir@,/pos
tgresql-7.1.3/src/test/regress,g’ -e ‘s/@DLSUFFIX@/.so/g’
output/create_function_1.sou
rce >expected/create_function_1.out