OS: Ubuntu 8.04
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.