#title PostgreSQL Cheatsheet
#author Stefan Hornburg (Racke)
#lang en
#topics PostgreSQL


** Create database user

<example>
create user sympa with password 'nevairbe';
</example>

** Create database for this user

<example>
create database sympa with owner = sympa;
</example>

** Clusters
#clusters

List clusters:

{{{
postgres@buster:~$ pg_lsclusters
Ver Cluster Port Status Owner    Data directory               Log file
9.4 main    5432 online postgres /var/lib/postgresql/9.4/main /var/log/postgresql/postgresql-9.4-main.log
11  main    5433 online postgres /var/lib/postgresql/11/main  /var/log/postgresql/postgresql-11-main.log
}}}