In earlier article, we installed PostgreSQL 10 in Linux and verify installation and service availability. We listed databases and users in our PostgreSQL instance. In this article, we will see how to convert a user to PostgreSQL server superuser database role.
In PostgreSQL, we can add user with following command.
ALTER USER user1 WITH SUPERUSER;
Lets see in Linux in a shell example.
In above example, we created a user for PostgreSQL server and converted it to superuser. In next article, we will see how to drop a user from database server.