Getting RT to work with postgres on debian. This work is with the
postgres 7.1.3-2 packages from debian testing on September 2, 2001. It
was done on a debian sparc linux machine, though it should work on
other linux machines.

RT wants to use password authentication, while debian postgres prefers
to use unix users. You will need to set a password for the postgres
DBA user, which the rt install will create tables as. To set the
password, su to postgres, run psql against the template1 database, and
set the postgres users password:

w-a-thornhump-iii:~# su postgres
w-a-thornhump-iii:/root$ psql template1
template1=# alter user postgres with password 'foo';
ALTER USER
template1=# \q

Now make the server accept password authentication. Edit
/etc/postgresql/pg_hba.conf to have the following non-comment lines:

local        all                                           password
host         all         127.0.0.1     255.0.0.0           password
host         all         0.0.0.0       0.0.0.0             reject