On Wed, Dec 23, 2009 at 15:39, Nicole Lim
<nicole.lim@ocean-is.com> wrote:
Hi there,
I have problem to add server by using the IP address like 192.168.xxx.xxx. It says the server refused to listen. I followed the guide by adding the line at the pg-hba but still the same.
Also, when I'm using the psqlodbc from the client machine, I can't connect. I can only connect using the Odbc when I'm at the local.
Hope you can give me some insight.
Thanks,
Nicole.
Check file postgresql.conf on the server. There are 2 settings, listen_addresses and port, which define where the server will be listening to connections. Default is localhost on port 5432.
You should change it to:
listen_addresses = '*' # means listen on every IP
port = 5432 # change only if its being used already by other apps
Afterwards, verify the line you added to pg_hba.conf looks like this:
This will enable a client from network 192.168.x.x to connect with any user to any database. MD5 password check will be enforced.
Regards,
Fernando.
