PostgreSQL: Difference between revisions

From annawiki
Line 1: Line 1:
==Name==
==Name==
#postgresql / PostgreSQL - postgresql.org
#postgresql / PostgreSQL
##postgresql.org
#pgsql - PL/pgSQL
#pgsql - PL/pgSQL
#postgres - https://wiki.postgresql.org/wiki/Postgres
##mod_pgsql
#psql - https://www.postgresql.org/docs/10/static/app-psql.html
#postgres
##https://wiki.postgresql.org/wiki/Postgres
#psql
##https://www.postgresql.org/docs/10/static/app-psql.html


==Creating cluster==
==Creating cluster==

Revision as of 2018-08-30T11:41:03

Name

  1. postgresql / PostgreSQL
    1. postgresql.org
  2. pgsql - PL/pgSQL
    1. mod_pgsql
  3. postgres
    1. https://wiki.postgresql.org/wiki/Postgres
  4. psql
    1. 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