Getting a new account set up on PostgreSQL is a simple process…
Create our new user:
Then you have to give this new user role a name (I called it daz), and then say ‘y’ to the question “Shall the new role be a superuser?” if you want the user to be an administrator.
Give the user a database password (this does not have to be the same as their unix password):
Finally, give the new user a database to play with:
Pretty straight forward… :)