#title PostgreSQL Cheatsheet
#author Stefan Hornburg (Racke)
#lang en
#topics PostgreSQL
** Create database user
create user sympa with password 'nevairbe';
** Create database for this user
create database sympa with owner = sympa;
** 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
}}}