Upgrade a User to be a Super User

In terminal run

sudo su postgres

After typing your password and getting in postgres type:

psql

Type your postgres password. Once you are in psql run

\du

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