PostgreSQL: Difference between revisions

From annawiki
No edit summary
Line 1: Line 1:
==Name==
#postgresql / PostgreSQL - postgresql.org
#pgsql - PL/pgSQL
#postgres - https://wiki.postgresql.org/wiki/Postgres
==Creating cluster==
==Creating cluster==
https://www.postgresql.org/docs/10/static/creating-cluster.html
https://www.postgresql.org/docs/10/static/creating-cluster.html

Revision as of 2018-08-26T11:10:02

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