[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 robe):

 We require  postgis extension to require super user because we haven't
 vetted all the pieces and it's too hard to vet.  For example postgis
 extension relies on other libraries, geos, proj and postgis_raster
 extension has even more.  So we are not prepared to mark it as trusted if
 that is what you are asking for.

 As Paul pointed out in the Aurora docs, that should work, and if it
 doesn't you should be bugging the Aurora support team about this.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5982#comment:2>
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.