[postgis-tickets] [PostGIS] #5212: Can't regress test PostGIS against sandboxed systems

[PostGIS]

#5212: Can't regress test PostGIS against sandboxed systems
-----------------------------------+---------------------------
 Reporter:  robe                   |      Owner:  strk
     Type:  defect                 |     Status:  new
 Priority:  medium                 |  Milestone:  PostGIS 3.2.3
Component:  build/upgrade/install  |    Version:  3.2.x
 Keywords:                         |
-----------------------------------+---------------------------
 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"
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5212>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.