Guest User

Untitled

a guest
Nov 16th, 2018
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. $ createuser -P -d -s -e my_user2 --host myhost.com -U my_user1
  2. Enter password for new role: XXXYYYZZZ
  3. Enter it again: XXXYYYZZZ
  4. Password: password1
  5. CREATE ROLE my_user2 PASSWORD 'md5999999c0101a1d64afd57575e06f999c' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
  6. createuser: creation of new role failed: ERROR: must be superuser to create superusers
  7. $
  8.  
  9. $ createuser -P -d -e my_user2 --host myhost.com -U my_user1
  10. Enter password for new role:
  11. Enter it again:
  12. Password:
  13. CREATE ROLE my_user2 PASSWORD 'md5999999c0101a1d64afd57575e06f888c' NOSUPERUSER CREATEDB NOCREATEROLE INHERIT LOGIN;
  14. $
  15.  
  16. dg+
Add Comment
Please, Sign In to add comment