Difference between revisions of "Postgres:User Creation"

From Earlham CS Department
Jump to navigation Jump to search
 
 
Line 1: Line 1:
 
To create a user in Postgres:
 
To create a user in Postgres:
  
# Log in/su over to the pgsql account.
+
# Log in/su over to the postgres account.
 
# The basic syntax is <tt>createuser ''username''</tt>.
 
# The basic syntax is <tt>createuser ''username''</tt>.
 
# <tt>createuser</tt> takes some useful switches:
 
# <tt>createuser</tt> takes some useful switches:

Latest revision as of 15:10, 14 November 2016

To create a user in Postgres:

  1. Log in/su over to the postgres account.
  2. The basic syntax is createuser username.
  3. createuser takes some useful switches:
    1. -D username cannot create databases.
    2. -d username can create databases.
    3. -A username cannot create more users.
    4. -a username can create more users.
    5. -P prompt for password for username.
    6. -E encrypt that password.