Establishing ODBC Connection to PostgreSQL Database

The back end database of the online survey application I built for my friend is PostgreSQL, and it is time for her to analyzing the data, using R, SAS, SPSS, or Excel. All these windows apt software provide ODBC based data importing utilities, so I need to establish ODBC condition for the PostgresSQL running on one UNIX server. The work is not as easy as what it looks like. Three hours are spent on it! Now I note down the key steps on the whole process.

1. Download and install PostgreSQL ODBC driver here.
2. Append one line in file pg_hbc.conf:

   host all all 102.102.102.102 255.255.255.0 trust

   '102.102.102.102' is the IP4 of the Windows client.
3. Edit postgresql.conf entries:

   listen_addresses = '*'
   port = 5432

4. Restart PostgreSQL server

The ODBC configuration on the Windows client machine is simple and is ommitted here.
Refer: PostgreSQL Manual, Chapter about 'Client Authentication'.