PostgreSQL

From annawiki
Revision as of 2018-08-26T11:10:02 by Tobiasco (talk | contribs)

Name

  1. postgresql / PostgreSQL - postgresql.org
  2. pgsql - PL/pgSQL
  3. postgres - https://wiki.postgresql.org/wiki/Postgres

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