Geoff_Montee

PostgreSQL 9.2. CREATEROLE

Apr 23rd, 2014
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.56 KB | None | 0 0
  1. [gmontee@localhost ~]$ psql -U postgres
  2. psql (8.4.20, server 9.2.8)
  3. WARNING: psql version 8.4, server version 9.2.
  4.          Some psql features might not work.
  5. Type "help" for help.
  6.  
  7. postgres=# CREATE ROLE rolecreator WITH LOGIN CREATEROLE;
  8. CREATE ROLE
  9. postgres=# \q
  10. [gmontee@localhost ~]$ psql -U rolecreator postgres
  11. psql (8.4.20, server 9.2.8)
  12. WARNING: psql version 8.4, server version 9.2.
  13.          Some psql features might not work.
  14. Type "help" for help.
  15.  
  16. postgres=> CREATE ROLE superuser WITH LOGIN SUPERUSER;
  17. ERROR:  must be superuser to create superusers
Advertisement
Add Comment
Please, Sign In to add comment