OS: Ubuntu 8.04
PostgreSQL: 8.3

By default, PostgreSQL database connection only listens to localhost. If you want to connect to a PostgreSQL database with another machine, 2 files needs to be modified.

1. Update /etc/postgresql/8.3/main/postgresql.conf. Set the listen_addresses from localhost to *

2. Update /etc/postgresql/8.3/main/pg_hba.conf. Add the following lines

• host    all    all    192.168.136.1/32    md5
• host    all    all    192.168.137.0/24    md5

3. Now, IP 192.168.136.1 as well as 192.168.137.* can connect to the PostgreSQL Database.

I would also like share a database tool which is called DBVisualizer. It is a java based software and so it can be run on any OS to access a wide range of different databases.
DBVisualizer Homepage

Enjoy =)