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
C:\Program Files\PostgreSQL\9.3\data\postgresql.conf :
lc_messages = 'en_US'
libeay32.dll libintl.dll libpq.dll ssleay32.dll