[PostGIS] #5525: ERROR: permission denied for view pg_file_settings

[PostGIS]

#5525: ERROR:  permission denied for view pg_file_settings
---------------------+---------------------------
  Reporter:  robe    |      Owner:  strk
      Type:  defect  |     Status:  assigned
  Priority:  medium  |  Milestone:  PostGIS 3.3.5
 Component:  build   |    Version:  3.3.x
Resolution:          |   Keywords:  pgextwlist
---------------------+---------------------------
Comment (by strk):

 Regina were you able to reproduce this problem ? CI is now running `CREATE
 EXTENSION` as an unprivileged user under pgextwlist and not showing any
 problem. I also cannot reproduce:

 {{{
 [strk at c19:/usr/local/src/postgis/postgis(main)] createdb test
 [strk at c19:/usr/local/src/postgis/postgis(main)] psql -f regress/hooks
 /configure-pgextwlist.sql test
 DO
 [strk at c19:/usr/local/src/postgis/postgis(main)] psql test
 psql (13.5 (Ubuntu 13.5-0ubuntu0.21.04.1))
 Type "help" for help.

 test=# set role postgis_sandboxed_user;
 SET
 test=> create extension postgis_topology cascade;
 NOTICE:  installing required extension "postgis"
 CREATE EXTENSION
 test=> select rolsuper from pg_roles where rolname = current_user;
  rolsuper
 ----------
  f
 (1 row)

 test=>
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5525#comment:20>
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.