Postgres:User Creation

From Earlham Cluster Department

Jump to: navigation, search

To create a user in Postgres:

  1. Log in/su over to the pgsql 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.
Personal tools
Namespaces
Variants
Actions
websites
wiki
this semester
Toolbox