Creating a new user in the PostgreSQL database server

In every database server, there should be one database administrator and many user clients. The administrator creates new users and defines roles for each user. Once you have installed the PostgreSQL onto your computer, the super user administrator will have been automatically defined under the postgres username. Now, you can create a new user using the postgres account. In this recipe, you will create a new user and define its role.

Getting ready

It is always good to create a new user and log in using the new user to create a database. In that case, you will always be in a safe situation, and you can easily avoid accidental damage to your database server. In this recipe...