Обсуждение: BUG #1728: unable to connect from other stations

The following bug has been logged online:

Bug reference:      1728
Logged by:          Christian Mercure
Email address:      christian_mercure@hotmail.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

and the following line in postgresql.conf
listen_addresses = '*'

Nothing works. What is required to connect from other stations.
If I cannot resolved this issues I will go with MySQL.

Thanks

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@hotmail.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