Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
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.×