PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> There's no point being able to create a database if one can't add the
> extensions one needs.
> We need postgis, postgis_topology, uuid-ossp, hstore
> How about adding a privilege to control this, instead of forcing the
> superuser password to be given out?
This is being worked on [1][2].
regards, tom lane
[1] https://www.postgresql.org/message-id/flat/5889.1566415762%40sss.pgh.pa.us
[2] https://www.postgresql.org/message-id/flat/32315.1580326876%40sss.pgh.pa.us