PostgreSQL Notes

1. Download
2. Documentation 9.4
3. Valentina Studio
4. Db Visualizer

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

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

sudo -u postgres createuser --superuser denis
createdb denis
psql

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

Check locales first.

pg_createcluster 9.4 main --start