Различия
Здесь показаны различия между двумя версиями данной страницы.
| Предыдущая версия справа и слева Предыдущая версия Следующая версия | Предыдущая версия | ||
|
dev:postgresql:notes [2015/04/22 15:04] denis [set password for the postgres user] |
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/download/|Download]] | ||
| - [[http://www.postgresql.org/docs/9.4/static/index.html|Documentation 9.4]] | - [[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 ===== | ===== install ===== | ||
| Строка 28: | Строка 30: | ||
| sudo service postgresql restart | sudo service postgresql restart | ||
| + | ===== create another superuser ===== | ||
| + | sudo -u postgres createuser --superuser denis | ||
| + | createdb denis | ||
| + | psql | ||
| ===== install adminpack ===== | ===== install adminpack ===== | ||
| psql | psql | ||
| Строка 52: | Строка 58: | ||
| \password | \password | ||
| type password for db-postgres user | 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 | ||
