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

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

On Fri, 24 Jun 2005, Christian Mercure wrote:

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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)