PostgreSQL Notes

1. Download
2. Documentation 9.4

sudo -u postgres psql postgres
\password postgres
enter password
\q

/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

psql
create extension "adminpack";

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