Re: BUG #1728: unable to connect from other stations

On Fri, 24 Jun 2005, Christian Mercure wrote:

>
> The following bug has been logged online:
>
> Bug reference: 1728
> Logged by: Christian Mercure
> Email address: christian_mercure(at)hotmail(dot)com
> PostgreSQL version: 8.0
> Operating system: Windows XP
> Description: unable to connect from other stations
> Details:
>
> I am evaluating backend server to use with Microsoft Access.
> I have installed MySQL and was easily able to connect to the server from
> network stations using ODBC data source.
>
> I am now evaluating PostGreSQL and cannot connect to it form other stations
> on the network.
> On the server I can create an ODBC file using localhost as the server name.
> It works and my Access frontend can connect to the server tables.
>
> When trying to connect from another station it does not work. I have tried
> to replace the server name localhost with the name of my server (example:
> DBSERVER), I have disable Windows XP firewall, I have put the following line
> in pg_hba.conf
>
> host all all 192.168.1.1/192.168.1.255 md5

I think you'd want something like 192.168.1.0/24 or 192.168.1.1
255.255.255.0 there. When I try something like the above I get

LOG: invalid entry in file "/usr/local/pgsql-8.0/data/pg_hba.conf" at
line 74, token "192.168.0.1/192.168.0.255"
FATAL: missing or erroneous pg_hba.conf file