I tried to execute
CREATE EXTENSION lo; in my db instance with the doadmin user. However it returns:
ERROR: permission denied to create extension “lo” HINT: Must be superuser to create this extension. SQL state: 42501
I found that the doadmin is not a superuser. How can I grant superuser privilege to doadmin? If I can’t, is there any solution?
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.
Click below to sign up and get $100 of credit to try our products over 60 days!