BUG #1728: unable to connect from other stations - Mailing list pgsql-bugs

From Christian Mercure
Subject BUG #1728: unable to connect from other stations
Date
Msg-id 20050624024052.5F2A0F0B01@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1728: unable to connect from other stations
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Harald Armin Massa
Date:
Subject: Re: Postgres Python API problem
Next
From: Stephan Szabo
Date:
Subject: Re: BUG #1728: unable to connect from other stations