[documentation] To connect a client to server using postgre dbase

February 10, 2012 at 4:00 am · Filed under Computer

Having a trouble connecting your client to server workstation which uses postgre dbase?

I experienced this when I wanted to try connecting a client to server in a web based application. Here are some tips:

1. open a file named pg_hba.conf in a text editor in server workstation, placed in C:\Program Files\PostgreSQL\8.4\data

2. edit this file, and write/add the computers’ client IP addresses, for example:

# TYPE     DATABASE      USER      CIDR-ADDRESS      METHOD
#IPv4 local connections:
host       all           all       10.16.12.1/32     md5
host      all           all      10.16.12.2/32     md5

=> orange: the additional ip address client

=> black: server ip address (by default)

3. save the file, restart the postgre server,  and enjoy the connection:D

Permalink