PostgreSQL Cheatsheet

Create database user

create user sympa with password 'nevairbe';

Create database for this user

create database sympa with owner = sympa;

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