postgres: upgrade a user to be a superuser?

In postgres, how do I change an existing user to be a superuser? I don't want to delete the existing user, for various reasons.

# alter user myuser ...?

Solution 1:

ALTER USER myuser WITH SUPERUSER;

You can read more at the Documentation

Solution 2:

To expand on the above and make a quick reference:

• To make a user a SuperUser: ALTER USER username WITH SUPERUSER;
• To make a user no longer a SuperUser: ALTER USER username WITH NOSUPERUSER;
• To just allow the user to create a database: ALTER USER username CREATEDB;

You can also use CREATEROLE and CREATEUSER to allow a user privileges without making them a superuser.

Documentation

Solution 3:

$ su - postgres
$ psql
$ \du; for see the user on db
select the user that do you want be superuser and:
$ ALTER USER "user" with superuser;