apt-get install ejabberd postgresql
mkdir ejabberd-modules
:~$ svn checkout http://svn.process-one.net/ejabberd-modules ejabberd-modules
:~$ cd ejabberd-modules/pgsql/trunk
:~/ejabberd-modules/pgsql/trunk$ ./build.sh
:~/ejabberd-modules/pgsql/trunk$ cd ebin
:~/ejabberd-modules/pgsql/trunk/ebin$ sudo cp * /usr/lib/ejabberd/ebin/
:~/ejabberd-modules/pgsql/trunk/ebin$ cd ~/
:~$ wget http://svn.process-one.net/ejabberd/tags/ejabberd-2.1.2/src/odbc/pg.sql
:~$ sudo su postgres -c psql template1
Welcome to psql 8.2.7, the PostgreSQL interactive terminal. Type: copyright for distribution terms h for help with SQL commands ? for help with psql commands g or terminate with semicolon to execute query q to quit
postgres=# ALTER USER postgres WITH PASSWORD ‘my_postgres_user_password_here’;
ALTER ROLE
...