PostgreSQL Regression Test

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

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
Creating directory
Creating template1 database in

Process 68522027 (postgres) terminated SIGBUS code=3 fltno=11 ip=b031c742
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.

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.


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 / 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
(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
chmod a+x pg_regress
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I…/…/…/s
ces/libpq -I…/…/…/src/include -c regress.c -o regress.o
gcc -shared -o regress.o
sed -e ‘s,@abs_srcdir@,/postgresql-7.1.3/src/test/regress,g’ -e
tgresql-7.1.3/src/test/regress,g’ -e ‘s/@DLSUFFIX@/.so/g’ input/copy.source


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


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


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