Re: Connection to a PG 8.0 Beta 1 win32 server
От | Magnus Hagander |
---|---|
Тема | Re: Connection to a PG 8.0 Beta 1 win32 server |
Дата | |
Msg-id | 6BCB9D8A16AC4241919521715F4D8BCE34C071@algol.sollentuna.se обсуждение исходный текст |
Ответ на | Connection to a PG 8.0 Beta 1 win32 server (Secrétariat <ets@rolland-fr.com>) |
Список | pgsql-general |
> > > > 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 That should be: host all all 192.168.0.0 255.255.255.0 md5 if you want the whole subnet. Or if you want just your W2k client: host all all 192.168.0.11 255.255.255.255 md5 //Magnus
В списке pgsql-general по дате отправления: