CODEWITHSUNDEEP
postgresqlregression-testing
thor
thor

Reputation: 22460

How can I get pg_regress?

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?

Upvotes: 3

Views: 2413

Answers (3)

Steve Chavez
Steve Chavez

Reputation: 1156

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.

Upvotes: 0

Janosimas
Janosimas

Reputation: 578

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

Upvotes: 3

Patrick
Patrick

Reputation: 32161

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.

Upvotes: 3

Related Questions