PostgreSQL: Difference between revisions

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

Revision as of 2018-08-30T10:42:27

Name

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