Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /home/users/p/prom-auto/domains/prom-auto.ru/wiki/inc/parser/handler.php on line 1458

Warning: Declaration of syntax_plugin_tablecalc::handle($match, $state, $pos, &$handler) should be compatible with DokuWiki_Syntax_Plugin::handle($match, $state, $pos, Doku_Handler $handler) in /home/users/p/prom-auto/domains/prom-auto.ru/wiki/lib/plugins/tablecalc/syntax.php on line 41

Warning: Declaration of syntax_plugin_tablecalc::render($mode, &$renderer, $data) should be compatible with DokuWiki_Syntax_Plugin::render($format, Doku_Renderer $renderer, $data) in /home/users/p/prom-auto/domains/prom-auto.ru/wiki/lib/plugins/tablecalc/syntax.php on line 72

Warning: Declaration of syntax_plugin_offline::handle($match, $state, $pos, &$handler) should be compatible with DokuWiki_Syntax_Plugin::handle($match, $state, $pos, Doku_Handler $handler) in /home/users/p/prom-auto/domains/prom-auto.ru/wiki/lib/plugins/offline/syntax.php on line 60

Warning: Declaration of syntax_plugin_offline::render($format, &$renderer, $data) should be compatible with DokuWiki_Syntax_Plugin::render($format, Doku_Renderer $renderer, $data) in /home/users/p/prom-auto/domains/prom-auto.ru/wiki/lib/plugins/offline/syntax.php on line 67

Warning: preg_match(): Compilation failed: invalid range in character class at offset 3416 in /home/users/p/prom-auto/domains/prom-auto.ru/wiki/inc/parser/lexer.php on line 118

A PCRE internal error occured. This might be caused by a faulty plugin

====== 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'