Regression Test Procedure

Postgres Regression Configuration

For a fresh install or upgrading from previous releases of Postgres:

1. Build the regression test. Type

       cd /usr/src/pgsql/src/test/regress
       gmake all
   

2. If you have prevously invoked the regression test, clean up the working directory with:

       cd /usr/src/pgsql/src/test/regress
       make clean
   

3. The file /usr/src/pgsql/src/test/regress/README has detailed instructions for running and interpreting the regression tests. A short version follows here:

   If the postmaster is not already running, start the postmaster on an available window by typing

       postmaster
   

   or start the postmaster daemon running in the background by typing

       cd
       nohup postmaster > regress.log 2>&1 &
   

   Run postmaster from your Postgres super user account (typically account postgres).

   NOTE: Do not run postmaster from the root account.

4. Run the regression tests. Type

       cd /usr/src/pgsql/src/test/regress
       gmake runtest
   

   You do not need to type "gmake clean" if this is the first time you are running the tests.

5. You should get on the screen (and also written to file ./regress.out) a series of statements stating which tests passed and which tests failed. Please note that it can be normal for some of the tests to "fail". For the failed tests, use diff to compare the files in directories ./results and ./expected. If float8 failed, type something like:

       cd /usr/src/pgsql/src/test/regress
       diff -w expected/float8.out results
   

6. After running the tests, type

       destroydb regression
       cd /usr/src/pgsql/src/test/regress
       gmake clean