Это старая версия документа.


PostgreSQL Notes

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

install adminpack

psql
create extension "adminpack";

change data folder

dev/postgresql/notes.1429694136.txt.gz · Последние изменения: 2015/04/22 12:15 — denis
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0