PostgreSQL – Grant super user privileges

To grant super user privileges to an existing database user, login as a super user and run the below sql statement where username is the name of the user.

alter user username superuser;
commit;                        

You can also grant super user privileges during user creation as below:

CREATE USER username PASSWORD 'password' SUPERUSER;
See also  PostgreSQL - WHERE Clause