The Ubuntu RT package usually likes to use sqlite3 so if you want to use postgreSQL instead it seems necessary to installed some other packages first:
Install Ubuntu 10.04 LTS as usual. Login and start a terminal as a normal user # set root password sudo bash (enter password) passwd (choose a root password) # for remote ssh login: aptitude install ssh # security updates aptitude update aptitude safe-upgrade # new kernal installed so: reboot aptitude search postgres-8.4 aptitude install apache2 aptitude install rt3.8-db-postgresql aptitude install exim4 # setup postgreSQL DB access using ident: cd /etc/postgresql/8.4/main/ vi pg_hba.conf # and comment out this: #local all postgres ident # and add this: local all all ident map=mymap vi pg_ident.conf # and append this: mymap root postgres mymap postgres postgres mymap root rtuser mymap rtuser rtuser mymap www-data rtuser /etc/init.d/postgresql-8.4 restart # now check (as root) that this works without a password: psql -U postgres # now install RT and it should do the postgreSQL setup of RT without needing # a database password - when prompted leave it blank aptitude install request-tracker3.8