Check Ubuntu Postgresql Manual first, which needs more care. For example, who and where (listen_addresses) can access the database.
marr@thrust:~$ sudo apt-get install postgresql-9.1 postgresql-server-dev-9.1 postgresql-client-9.1
marr@thrust:~$ sudo -u postgres createuser -D -A -P myuser
Enter password for new role:
Enter it again:
Shall the new role be allowed to create more new roles? (y/n)
marr@thrust:~$ sudo -u postgres createdb -O myuser mydb
marr@thrust:~$ sudo vi /etc/postgresql/9.1/main/pg_hba.conf
marr@thrust:~/$ sugo apt-get install python-virtualenv
marr@thrust:~/$ virtualenv myenv
marr@thrust:~/$ cd myenv
marr@thrust:~/myenv$ source bin/activate
(myenv)marr@thrust:~/myenv$ git clone git://github.com/ASKBOT/askbot-devel.git
(myenv)marr@thrust:~/myenv$ cd askbot-devel
(myenv)marr@thrust:~/myenv/askbot-devel$ python setup.py develop
(myenv)marr@thrust:~/myenv$ pip install psycopg2
$ askbot-setup
Deploying Askbot - Django Q&A forum application
Problems installing? -> please email admin@askbot.org
To CANCEL - hit Ctr-C at any time
Enter directory path (absolute or relative) to deploy
askbot. To choose current directory - enter "."
> /home/marr/askbot
Adding new directories:
/home/marr <-/askbot
Accept? (type yes/no)
> yes
Please do not name your entire Django project 'askbot',
because this name is already used by the askbot app itself
Please select database engine:
1 - for postgresql, 2 - for sqlite, 3 - for mysql, 4 - oracle (type 1/2/3/4)
Please enter database name (required)
Please enter database user (required)
Please enter database password (required)
Copying files:
* __init__.py
* manage.py
* urls.py
* django.wsgi
Creating settings file
settings file created
copying directories: * doc
* cron
* upfiles
Done. Please find further instructions at http://askbot.org/doc/
$ python manage.py syncdb
WARNING!!! You are using a 'locmem' (local memory) caching backend,
which is OK for a low volume site running on a single-process server.
For a multi-process configuration it is neccessary to have a production
cache system, such as redis or memcached.
With local memory caching and multi-process setup you might intermittently
see outdated content on your site.
Please run command
python manage.py collectstatic
current transaction is aborted, commands ignored until end of transaction block
Syncing...
Creating tables ...
Creating table auth_permission
Creating table auth_group_permissions
Creating table auth_group
Creating table auth_user_user_permissions
Creating table auth_user_groups
Creating table auth_user
Creating table auth_message
Creating table django_content_type
Creating table django_session
Creating table django_site
Creating table django_admin_log
Creating table south_migrationhistory
Creating table livesettings_setting
Creating table livesettings_longsetting
Creating table djkombu_queue
Creating table djkombu_message
Creating table followit_followuser
You just installed Django's auth system, which means you don't have any superusers defined.
Would you like to create one now? (yes/no):
$ python manage.py syncdb
$ python manage.py migrate askbot
WARNING!!! You are using a 'locmem' (local memory) caching backend,
which is OK for a low volume site running on a single-process server.
For a multi-process configuration it is neccessary to have a production
cache system, such as redis or memcached.
With local memory caching and multi-process setup you might intermittently
see outdated content on your site.
Please run command
python manage.py collectstatic
Photos by