In terminal run
sudo su postgres
After typing your password and getting in postgres type:
Type your postgres password. Once you are in
to see all your users. Notice the table that is displayed, and pay attention to the List of roles attributes column.
Once you know what user you are giving super user permissions, run:
ALTER USER <user> SUPERUSER;
To confirm the changes run again
\du. You should see your user with the new role Superuser.
That's it, hope this help someone!
Photo by Mehdi Babousan on Unsplash
Top comments (0)