sudo nano /etc/apt/sources.list.d/pgdg.list
# - Add
# deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main
# - and save
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.3 libpq-dev
sudo nano /etc/postgresql/9.3/main/pg_hba.conf
# - Change
# local all all peer
# - to
# local all all md5
sudo /etc/init.d/postgresql reload
sudo -u postgres createuser -D -A -P myuser
sudo -u postgres createdb -O myuser mydb
If you want to allow access from public Internet:
sudo nano /etc/postgresql/9.3/main/postgresql.conf
# - Change
# #listen_addresses = 'localhost'
# - to
# listen_addresses = '*'
# - save
sudo nano /etc/postgresql/9.3/main/pg_hba.conf
# - add (use 0.0.0.0/0 for all IP's)
# host all all <EXTERNAL IP>/32 md5
sudo /etc/init.d/postgresql restart