Re: Add server error

[Fernando Hevia <fhevia(at)gmail(dot)com>]

On Wed, Dec 23, 2009 at 15:39, Nicole Lim <nicole(dot)lim(at)ocean-is(dot)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:

host    all         all         192.168.0.0/16           md5

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.