Linux Hints

pip needs the following in order to work correctly: http://stackoverflow.com/questions/5178416/pip-install-lxml-error/5178444#5178444

$ sudo apt-get install libxml2-dev $ sudo apt-get install libxslt1-dev

$ sudo apt-get install python2.7-dev

when getting postgres to work, better to just do a clean install, http://stackoverflow.com/questions/2748607/how-to-thoroughly-purge-and-reinstall-postgresql-on-ubuntu

$ sudo apt-get purge postgresql $ sudo apt-get autoremove postgresql

Finally to install postgres use aptitude instead of apt-get,

$ sudo aptitude install postgresql postgresql-contrib $ sudo aptitude install pgadmin3

once in the postgres, EXTREMELY IMPORTANT go to alternative server setup, set the user to root on this page as per the instructions on this page: https://help.ubuntu.com/community/PostgreSQL

you'll have to switch users to root, simple go: $ su - root then enter the password.

Now from there you can execute all the commands and it will never complain.

Warning: this process may involve creating a user called postgres and changing the password for various users, you can do that easily with a little googling