BUG #17281: How specify regress database?

On Thu, Nov 11, 2021, at 6:08 AM, PG Bug reporting form wrote:

I try
1) add in Makefile
CONTRIB_TESTDB = postgres
2) add in Makefile
REGRESS_OPTS = --use-existing --dbname=postgres
3) add in Makefile
EXTRA_REGRESS_OPTS = --use-existing --dbname=postgres
4) before calling make installcheck
export CONTRIB_TESTDB=postgres
but results everything is same:
/usr/lib/postgresql/pgxs/src/makefiles/../../src/test/regress/pg_regress
--inputdir=./ --bindir='/usr/bin' --use-existing --dbname=postgres
--dbname=contrib_regression extension
i.e. pgxs places --dbname=contrib_regression in last option due to
/messages/by-id/14108.1314148639@sss.pgh.pa.us

This is not a bug. Use the appropriate list for your question next time.

AFAICS there is not a configurable way to change the CONTRIB_TESTDB. Unless,
you modify Makefile.global.in. You might modify configure.ac to inform a
configurable database for the CONTRIB_TESTDB too.

--
Euler Taveira
EDB https://www.enterprisedb.com/

"Euler Taveira" <euler@eulerto.com> writes:

This is not a bug. Use the appropriate list for your question next time.

Indeed.

AFAICS there is not a configurable way to change the CONTRIB_TESTDB.

Doesn't it work to set that after including the global Makefile?
I thought make's rule was last-one-wins. Another thing worth
experimenting with is to set it using ":=" rather than "=".

Also, it should work to override it from the command line, viz

make check CONTRIB_TESTDB=foo

although I gather the OP wants to set it in his own Makefile.

regards, tom lane