Postgresql database cluster enable extension
After creating the cluster I want to enable a supported extension
Using psql I check the available extensions:
SELECT * FROM pg_available_extensions order by name;
and see all the available extensions and that the installed version is null.
If I want to enable the extension using
create extension insert_username
I get the following error:
ERROR: permission denied to create extension "insert_username" HINT: Must be superuser to create this extension. SQL state: 42501
Creating a new user with superuser privileges doesn’t work, because doadmin isn’t a superuser, what to do?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.