Re: making the testsuite installable

Re: Pavel Raiskup 2014-11-18 <13115650(dot)4ECf6iphU0(at)nb(dot)usersys(dot)redhat(dot)com>
> Hello all.
>
> My issue with current testsuite solution:
>
> The testsuite requires 'root' account. Thats needed because successful run
> requires PostgreSQL properly configured and running. This is hardly
> achievable during package build because (e.g. in Fedora) we build packages
> under non-privileged user.
>
> Running git testsuite against distributed psqlodbc is not comfortable so
> I doubt users run the testsuite. Running the testsuite automatically is
> not trivial.
>
> It would be really nice to have the testsuite installed with 'make
> install'. That would allow us to package the testsuite as separated
> (sub)package and distribute it to end-users (who should be able to have
> enough privileges). It would also allow me to write privileged scripts
> for downstream testing.

The Debian package uses a temporary cluster created by the buildd user
to run the tests:
http://anonscm.debian.org/cgit/pkg-postgresql/psqlodbc.git/tree/debian/tests/buildtime

pg_virtualenv is at
https://alioth.debian.org/scm/loggerhead/pkg-postgresql/postgresql-common/trunk/view/head:/pg_virtualenv

> Would you be interested in patches implementing this? ..
> * adding option ./configure --enable-dist-tests (default off)
> * make tests sub-directory autoreconfed

We have some troubles here too because we are building out-of-tree,
while the testsuite is run in tree, but so far this worked:

clean::
# tests are run in tree, while configure is OOT
$(MAKE) -C test -f Makefile.in distclean PG_CONFIG=pg_config

Christoph
--
cb(at)df7cb(dot)de | http://www.df7cb.de/