====== PostgreSQL Notes ====== - [[http://www.postgresql.org/download/|Download]] - [[http://www.postgresql.org/docs/9.4/static/index.html|Documentation 9.4]] ===== 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 ===== 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