User management

Examples

• 1

  Create user and matching database

  edit move example delete share

  1

  To support a given application, you often create a new user and database to match.

  The shell commands to run would be these:

  $ createuser -P blogger
  Enter password for the new role: ⚫⚫⚫⚫⚫⚫⚫⚫
  Enter it again: ⚫⚫⚫⚫⚫⚫⚫⚫
  
  $ createdb -O blogger blogger
  

  This assumes that pg_hba.conf has been properly configured, which probably looks like this:

  # TYPE  DATABASE        USER            ADDRESS                 METHOD
  host    sameuser        all             localhost               md5
  local   sameuser        all                                     md5
  

  created 2 days ago

  
• 0

  Create a user with a password

  edit move example delete share

  0

  This will create a PostgreSQL user with niceusername username and very-strong-password password.

  CREATE USER niceusername with PASSWORD 'very-strong-password';
  

  created Jul 21 at 19:57