http://www.thegeekstuff.com/2009/04/15-practical-postgresql-database-adminstration-commands/ There are two methods in which you can create user. Method 1: Creating the user in the PSQL prompt, with CREATE USER command. # CREATE USER ramesh WITH password 'tmppassword'; Method 2: Creating the user in the shell prompt, with createuser command. $ /usr/local/pgsql/bin/createuser sathiya Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) n Shall the new role be allowed to create more new roles? (y/n) n CREATE ROLE
