POSTGRESQL-install ubuntu14.04

Ubuntu postgresql 9.3 installation for RoR

Add repository and install Postgresql:

COPY
sudo sh -c "echo 'deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main' > /etc/apt/sources.list.d/pgdg.list"

COPY
wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -

COPY
sudo apt-get update

COPY
sudo apt-get install postgresql-common

COPY
sudo apt-get install postgresql-9.3 libpq-dev

Then make yourself a Postgresql superuser:

COPY
sudo su postgres

COPY
createuser your_system_login

COPY
psql

COPY
ALTER ROLE your_system_login WITH SUPERUSER;

COPY
\q

COPY
exit

After that you can run postgresql console with command:

COPY
psql postgres

Setup postgres for RoR: setup postgres for RoR