enable remote access PostgreSQL

In default, for security reason, postgreSQL doesn't allow to be accessed remoted.
But, we can configure it so it can be accessed remotely.

Below is the step to do that with follow the steps I done with postgreSQL8.2 in Ubuntu OS
1. Login as postgres
# su - postgres
2. edit configuration file (pg_hba.conf)
# vi /etc/postgresql/8.2/main/pg_hba.conf
append below line to that file:
host all all 192.168.1.0/24 trust

where 192.168.1.0 is IP configuration in your network
3. edit configuration file: postgresql.conf to allow TCP/IP socket
# vi /etc/postgresql/8.2/main/postgresql.conf
find line:
listen_addresses='localhost'
and change into:
listen_addresses='*'


4. restart postgreSQl with:
# /etc/init.d/postgresql-8.2 restart

Finisih