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

postgres=# \c rezepte You are now connected to database “rezepte” as user “postgres”.