3

From online documentation, it seems that that there is a pg_regress program/component for regression tests. 

REGRESS_OPTS

    additional switches to pass to **pg_regress**

I can do simple regression tests (under postgresql coming from Ubuntu 16.04 LTS), but couldn't find the program pg_regress itself or see its options. 

$ pg_regress
pg_regress: command not found

which pg_regress returns empty.

Do I need to install additional packages to get pg_regress or is it hidden somewhere?

thor
  • 21,418
  • 31
  • 87
  • 173

3 Answers3

3

pg_regress is available from the source code repository. If you installed PostgreSQL through a package manager or as a binary, it will not be included. Regression testing is typically done after you build the code yourself, for instance with a new release.

Patrick
  • 29,357
  • 6
  • 62
  • 90
2

For future reference, the pakcage postgresql-server-dev-9.5 has the pg_regress but it's not in the path. You can find it at: /usr/lib/postgresql/9.5/lib/pgxs/src/test/regress/pg_regress

Janosimas
  • 570
  • 7
  • 17
0

I was also trying to see what options pg_regress offers. The simplest way I found was to add the -h option to the Makefile of the library/extension you're building. Like:

REGRESS_OPTS = "-h"

Then doing make installcheck will show the options.

Steve Chavez
  • 931
  • 10
  • 13