* 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 * In /etc/postgresql/X.Y/postgresql.conf change listen_address to '*'. 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 (postgresql-contrib-X.Y package): For 8.x: psql odb_test -f /usr/share/postgresql/8.4/contrib/hstore.sql For 9.x: psql odb_test CREATE EXTENSION hstore;