Permission denied to create extension "extension_name" HINT: Must be superuser to create this extension postgres

If you want install a extension in your postgresql database via python manage.py migrate it will throw an error if database user is not a super user. We can resolve this issue by give superuser permission to our current user. We can also withdraw super user permission after that 😬.

Login psql by current user via -

sudo -u postgres psql

then ->

postgres-# alter role <user_name> superuser;

this user should be in your database config user profile -

exit from database by -

\q 

Then you can successfully migrate.

Oh! hold on
If you want alter super user permission by after login with current user in psql -

postgres-# alter role <user_name> nosuperuser;

Thank you...