Re: Connection to a PG 8.0 Beta 1 win32 server - Mailing list pgsql-general

From Gaetano Mendola
Subject Re: Connection to a PG 8.0 Beta 1 win32 server
Date
Msg-id 412B22E4.20503@bigfoot.com
Whole thread Raw
In response to Re: Connection to a PG 8.0 Beta 1 win32 server  (Secrétariat <ets@rolland-fr.com>)
List pgsql-general
Secrétariat wrote:

>
>>>>Hello !
>>>>
>>>>I've installed the Beta 1 on Win XP Pro, it seem working correctly.
>>>>I load a database from Linux 7.4.3 with pgdumpall, it works too.
>>>>But I can't connect from other PC over the LAN (I modified pg_hba.conf
>>>>for the hosts).
>>>>If I write in postgresql.conf :
>>>>tcpip_socket = true
>>>>port = 5432
>>>>I can't connect from the LAN,  NEITHER from the local machine ?!
>>>>Where I've made a mistake ?
>>>
>>>Show us your pg_hba.conf, what is the exact error ?
>>>
>
> Beta 1 Win32 server at 192.168.0.10,
> W2k client at 192.168.0.11.
> My pg_hba.conf :
> # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
> local all all md5
> # IPv4-style local connections
> host all all 127.0.0.1     255.255.255.255 md5
> host all all 192.168.0.0 255.255.255.255 md5
> # IPv6-style local connections:
> #host all all ::1/128 md5

If you want allow all the network 192.168.0.0 then
your netmask have to be: 255.255.0.0



Regards
Gaetano Mendola



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bad planner results
Next
From: Gaetano Mendola
Date:
Subject: Re: Python and 8.0 beta