Advertisement
Guest User

Untitled

a guest
Feb 5th, 2020
209
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. #### Step 02
  2. ############
  3.  
  4.  
  5. trytfan@debian:~$ sudo -u postgres psql
  6. [sudo] Passwort für trytfan:
  7. psql (11.5 (Debian 11.5-1+deb10u1))
  8. Geben Sie »help« für Hilfe ein.
  9.  
  10. postgres=# CREATE DATABASE tryton_test WITH OWNER = postgres ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C' TABLESPACE = pg_default CONNECTION LIMIT = -1 TEMPLATE template0;
  11. CREATE DATABASE
  12. postgres=# CREATE ROLE tryton_test WITH LOGIN NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT NOREPLICATION CONNECTION LIMIT -1 PASSWORD 'tryton_test';
  13. CREATE ROLE
  14.  
  15.  
  16. postgres=# \list
  17. Liste der Datenbanken
  18. Name | Eigentümer | Kodierung | Sortierfolge | Zeichentyp | Zugriffsprivilegien
  19. -------------+------------+-----------+--------------+-------------+-----------------------
  20. postgres | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 |
  21. template0 | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres +
  22. | | | | | postgres=CTc/postgres
  23. template1 | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres +
  24. | | | | | postgres=CTc/postgres
  25. tryton_test | postgres | UTF8 | C | C |
  26. (4 Zeilen)
  27.  
  28. postgres=# \q
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement