Install pg 9.1 (Ubuntu 12.04)

pg install.markdown

Install pg server

sudo apt-get install postgresql

Install client

sudo apt-get install pgadmin3

Install dev tools

sudo apt-get install libpq-dev

Basic Setup

To start off, we need to change the PostgreSQL pg user password; we will not be able to access the server otherwise

sudo su
root# passwd postgres

sudo -u postgres psql postgres
\password postgres
# enter password and confirm
# ctrl + d to exit pg prompt

Add new user

sudo -u postgres createuser --superuser new_user
sudo -u postgres psql postgres
postgres-# \password new_user
Enter new password: 
Enter it again: 

# Edit sudo vim /etc/postgresql/9.1/main/pg_hba.conf
# "local" is for Unix domain socket connections only
local   all         all                               md5