PostgreSQL: Difference between revisions

From annawiki
Line 2: Line 2:
#postgresql / PostgreSQL
#postgresql / PostgreSQL
##postgresql.org
##postgresql.org
#pgsql - PL/pgSQL
#pgsql
##PL/pgSQL
##mod_pgsql
##mod_pgsql
#postgres
#postgres

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

Name

  1. postgresql / PostgreSQL
    1. postgresql.org
  2. pgsql
    1. PL/pgSQL
    2. 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