Can't regress test PostGIS using non-superuser PostgreSQL role (cannot set lc_messages)

[robe]

I was using pgtwlist to try to simulate a sandboxed user such as one would find in a classroom or in a cloud setup.

Basic steps in my setup, I install the ​https://github.com/dimitri/pgextwlist.git extension, restart the postgresql service

ALTER SYSTEM SET extwlist.extensions='postgis,postgis_topology,postgis_sfcgal, address_standardizer,postgis_tiger_geocoder'; 
SELECT pg_reload_conf();

The user I created, has rights to create databases but is not a super user, and I confirmed I can do CREATE EXTENSION postgis with this user.

When I try to regress though, I get an error

> "/var/run/postgresql/.s.PGSQL.5433" failed: FATAL:  permission denied 
> to set parameter "lc_messages"

[strk]

CI coverage of sandboxed systems ticket filed: #5566

[strk]

I could have woodie reproduce this: ​https://woodie.osgeo.org/repos/30/pipeline/1293/69#L2307

[strk]

The lc_messages setting was added in 2006 to force C locale with [81943a774a0bc2d046592736b3c9e5a35fffe29e/git] — we'd need a way to request C locale that doesn't require superuser permission. It's currently done by run_test.pl

[Sandro Santilli <strk@…>]

In 5739cacd/git:

run_test.pl: add POSTGIS_REGRESS_DB_OWNER env support

Allows specifying a DB role to be given ownership of the regress
database and be used to create extension of POSTGIS_REGRESS_EXT_CREATOR
is not also provided to override that.

References #5212
References #5566
References #5567

[strk]

I think we can close this as won't-fix as in order to load postgis function you'll need superuser anyway. Surely for script based and also for extension based unless we turn the extension into a trusted one ( ref #5567 ).

Sandboxed based testing is now supported and used by Woodie.

Regina: feel free to reopen if you disagree