✎ PostgreSQL Notes [ПромАвтоматика]

Эта страница только для чтения. Вы можете посмотреть исходный текст, но не можете его изменить. Сообщите администратору, если считаете, что это неправильно.

====== PostgreSQL Notes ======
  - [[http://www.postgresql.org/download/|Download]]
  - [[http://www.postgresql.org/docs/9.4/static/index.html|Documentation 9.4]]
  - [[https://www.valentina-db.com/en/download-valentina-studio/current|Valentina Studio]]
  - [[http://www.dbvis.com/download/|Db Visualizer]]

===== install =====

// sudo gedit /etc/apt/sources.list.d/pgdg.list //:
  deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main

  wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
  sudo apt-get update 
  apt-get install postgresql-9.4 postgresql-contrib pgadmin3

===== set password for the postgres user =====
  sudo -u postgres psql postgres
  \password postgres
  enter password
  \q
  
===== authentication =====
  /etc/postgresql/9.4/main/pg_hba.conf:
  local   all             all             trust
  host    all             all             0.0.0.0/0               md5
  
''/etc/postgresql/9.4/main/postgresql.conf'':
  listen_addresses = '*'

  sudo service postgresql restart

===== create another superuser =====
  sudo -u postgres createuser --superuser denis
  createdb denis
  psql
===== install adminpack =====
  psql
  create extension "adminpack";
  
===== change data folder =====
  passwd postgres
  type password for unix-postgres user

  mkdir /media/store/asutp/promauto/db/pgdata
  sudo chown postgres:postgres /media/store/asutp/promauto/db/pgdata
  sudo chmod 700 /media/store/asutp/promauto/db/pgdata

  su - postgres
  /usr/lib/postgresql/9.4/bin/initdb -D /media/store/asutp/promauto/db/pgdata
  exit
  sudo service postgresql stop

// /etc/postgresql/9.4/main/postgresql.conf //:
  data_directory = '/media/store/asutp/promauto/db/pgdata'

  sudo service postgresql start
  psql
  \password
  type password for db-postgres user
  
===== no cluster problem =====
Check [[dev:ubuntu:setupsvr#locales|locales]] first.
  pg_createcluster 9.4 main --start

===== error messages in english =====

// C:\Program Files\PostgreSQL\9.3\data\postgresql.conf //:
  lc_messages = 'en_US'