myuser=> CREATE EXTENSION postgis;
ERROR:  permission denied to create extension "postgis"
HINT:  Must be superuser to create this extension.

postgres=> ALTER USER myuser WITH SUPERUSER;
ERROR:  must be superuser to alter superusers