PostgreSQL

Name

1. postgresql / PostgreSQL - postgresql.org
2. pgsql - PL/pgSQL
3. postgres - https://wiki.postgresql.org/wiki/Postgres
4. psql - https://www.postgresql.org/docs/10/static/app-psql.html

Creating cluster

https://www.postgresql.org/docs/10/static/creating-cluster.html

"/usr/local/pgsql/data or /var/lib/pgsql/data are popular"

• in Ubuntu 'apt-get install postgresql' creates /var/lib/postgresql/

initdb not found

• https://askubuntu.com/questions/371737/install-postgresql-why-is-initdb-unavailable
• https://superuser.com/questions/513386/setting-up-postgresql-gives-error-sudo-initdb-command-not-found