Im using the postgresql 8.0 here:
1. Modifiy the file: /etc/postgresql/8.0/main/pg_hba.conf
add a line below the "# IPv4 local connections:"
host all all 192.168.0.0/24 md5
2. Modify the file: /etc/postgresql/8.0/main/postgresql.conf
set the Connection Settings like below:
# - Connection Settings -
listen_addresses = '*' # what IP interface(s) to listen on;
# defaults to localhost, '*' = any
port = 5432
max_connections = 100
3. Restart the postgresql 8.0
4. Now we can connect to postgresql server using clients.
for eg.
psql -d DBNAME -U USERNAME -h HOST