Различия

Здесь показаны различия между двумя версиями данной страницы.

--- dev:postgresql:notes [2015/04/22 14:54]
denis [change data folder]
+++ dev:postgresql:notes [2015/05/15 20:36] (текущий)
denis [error messages in english]
@@ Строка 2: / Строка 2: @@
   - [[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 =====
@@ Строка 19: / Строка 30: @@
   sudo service postgresql restart
+===== create another superuser =====
+  sudo -u postgres createuser --superuser denis
+  createdb denis
+  psql
 ===== install adminpack =====
   psql
@@ Строка 43: / Строка 58: @@
   \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'
+===== client windows dll =====
+  libeay32.dll
+  libintl.dll
+  libpq.dll
+  ssleay32.dll