[PostGIS] #5982: CREATE EXTENSION POSTGIS must be done as SUPERUSER

[PostGIS]

#5982: CREATE EXTENSION POSTGIS must be done as SUPERUSER
--------------------------+---------------------------
  Reporter:  bceccarelli  |      Owner:  pramsey
      Type:  defect       |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS 3.6.1
 Component:  postgis      |    Version:  3.5.x
Resolution:               |   Keywords:
--------------------------+---------------------------
Comment (by pramsey):

 I am pretty sure Aurora Pg allows PostGIS to be run, the docs certainly
 seem to say so

 https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Appendix.PostgreSQL.CommonDBATasks.PostGIS.html

 Like most C extensions, we are not marking ourselves as a "trusted"
 extension suitable for installation by non-superusers. It's possible
 that's how Aurora is doing it (marking their copy trusted, since it's
 their copy).
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5982#comment:1>
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.