Setup postgresql on Ubuntu for using from django

# how to prepare clean Ubuntu for developmetn and testing

sudo apt-get -y install mc

# database engine
sudo apt-get -y install postgresql

# client tools
sudo apt-get -y install pgadmin3

sudo apt-get -y install python-psycopg2
sudo apt-get -y install python-setuptools
sudo apt-get -y install subversion

# create dir for third parthy
mkdir ~/apps

# django
svn co http://code.djangoproject.com/svn/django/trunk ~/apps/django-trunk
cd ~/apps/django-trunk
sudo python setup.py install

# db-templates
sudo easy_install django-dbtemplates

# filebrowser
svn co http://django-filebrowser.googlecode.com/svn/trunk/filebrowser/ ~/apps/filebrowser
sudo ln -s ~/apps/filebrowser /usr/lib/python2.6/dist-packages/filebrowser

# django-tinymce
cd /tmp
wget http://django-tinymce.googlecode.com/files/django-tinymce-1.5.tar.gz
tar xzvf django-tinymce-1.5.tar.gz
cd django-tinymce-1.5
sudo python setup.py install


# copy install folder to ~/tmp

# install Komodo ide
cd ~/tmp/install/komodo
tar -xvzf Komodo-IDE-5.1.3-28369-linux-libcpp6-x86.tar.gz
cd Komodo-IDE-5.1.3-28369-linux-libcpp6-x86
sudo ./install.sh -I /usr/local/Komodo-IDE-5
mkdir ~/.ActiveState
cp ~/tmp/install/komodo/ActiveState.lic ~/.ActiveState


# my projects
mkdir ~/projects
svn co file:////media/disk/projects/svn/web-projects ~/projects/web-projects
sudo ln -s ~/projects/web-projects/trunk/apps/showcase /usr/lib/python2.6/dist-packages/showcase
sudo ln -s ~/projects/web-projects/trunk/apps/hpages /usr/lib/python2.6/dist-packages/hpages



# create user for postgres
sudo su - postgres
createuser -S -d -R -E -P pguser

# Modify /etc/postgresql/8.2/main/pg_hba.conf to require password authentication for local connections:
# Comment or remove any existing lines at the end of the file, then append this:
#local all all password

sudo /etc/init.d/postgresql-8.3 restart

# create database:
createdb --encoding=UTF-8 --username=pguser --password db_name