Installation
sudo apt-get install postgresql postgresql-client postgresql-contrib
Changing the User Password
sudo -u postgres psql postgres
ALTER USER postgres WITH ENCRYPTED PASSWORD ‘<***password***>’;
q
Creating a New DB
sudo -u postgres createdb dev
Setting up PgAdmin III
Don’t know exactly what this is good for, better performance?
sudo -u postgres psql < /usr/share/postgresql/8.3/contrib/adminpack.sqll
Installing PgAdmin III
sudo aptitude install pgadmin3