Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #### Step 02
- ############
- trytfan@debian:~$ sudo -u postgres psql
- [sudo] Passwort für trytfan:
- psql (11.5 (Debian 11.5-1+deb10u1))
- Geben Sie »help« für Hilfe ein.
- postgres=# CREATE DATABASE tryton_test WITH OWNER = postgres ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C' TABLESPACE = pg_default CONNECTION LIMIT = -1 TEMPLATE template0;
- CREATE DATABASE
- postgres=# CREATE ROLE tryton_test WITH LOGIN NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT NOREPLICATION CONNECTION LIMIT -1 PASSWORD 'tryton_test';
- CREATE ROLE
- postgres=# \list
- Liste der Datenbanken
- Name | Eigentümer | Kodierung | Sortierfolge | Zeichentyp | Zugriffsprivilegien
- -------------+------------+-----------+--------------+-------------+-----------------------
- postgres | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 |
- template0 | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres +
- | | | | | postgres=CTc/postgres
- template1 | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres +
- | | | | | postgres=CTc/postgres
- tryton_test | postgres | UTF8 | C | C |
- (4 Zeilen)
- postgres=# \q
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement