postgres=# \password postgres Enter new password for user “postgres”: Enter it again:

postgres=# create user rezepte with password 'somepassword'; CREATE ROLE

postgres=# create database rezepte with owner rezepte; CREATE DATABASE

postgres=# \conninfo You are connected to database “postgres” as user “postgres” via socket in “/var/run/postgresql” at port “5432”.

postgres-# \l

                                List of databases
 Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges

———–+———-+———-+————-+————-+———————– postgres | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | rezepte | rezepte | 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