As user postgres I try and run the tests:
$ pwd /usr/lib/pgsql/test/regress $ time ./pg_regress.sh --schedule=parallel_schedule ... ==================================================== 6 of 93 tests failed, 1 of these failures ignored. ====================================================
This problem is caused by the postgresql-test rpm. The tests depend on a Makefile being present at a higher level, from the source build.
$ pwd /usr/lib/pgsql/test/regress $ gmake check GNUmakefile:16: ../../../src/Makefile.global: No such file or directory gmake: *** No rule to make target `../../../src/Makefile.global'. Stop.
$ chmod +x ./pg_regress.sh
Change/add the following variable set in pg_regress.sh:
bindir=/usr/bin libdir=/usr/lib/pgsql pkglibdir=/usr/lib/pgsql datadir=/var/lib/pgsql VERSION=7.4.2 host_tuple= GMAKE=gmake enable_shared=yes GCC=yes
$ time ./pg_regress.sh --schedule=parallel_schedule ... test create_function_1 ... FAILED ... ======================= 1 of 93 tests failed. =======================
$ cat ./regression.diffs
*** ./expected/create_function_1.out Wed Mar 10 13:36:51 2004
--- ./results/create_function_1.out Sat Oct 2 15:20:50 2004
***************
*** 70,76 ****
ERROR: could not access file "nosuchfile": No such file or directory
CREATE FUNCTION test1 (int) RETURNS int LANGUAGE c
AS '/usr/lib/pgsql/test/regress/regress.so', 'nosuchsymbol';
! ERROR: Can't find function nosuchsymbol in file /usr/lib/pgsql/test/regress/regress.so
Not sure what this is. The postgresql-test rpm needs some massaging I think.
--- John