* In /etc/postgresql/X.Y/pg_hba.conf add the following two lines after
  the "local all postgres ..." line:

local   odb_test        odb_test                                trust
host    odb_test        odb_test        192.168.0.0/24          trust

  Restart the server.

* Add user and database:

  su postgres
  psql
    create user odb_test;
    create database odb_test;
    grant all privileges on database odb_test to odb_test;

* If need to add hstore support:

  psql odb_test -f /usr/share/postgresql/8.4/contrib/hstore.sql