Skip site navigation (1) Skip section navigation (2)

Re: Connection to a PG 8.0 Beta 1 win32 server

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: Secrétariat <ets(at)rolland-fr(dot)com>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: Connection to a PG 8.0 Beta 1 win32 server
Date: 2004-08-24 08:16:14
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE34C071@algol.sollentuna.se (view raw or flat)
Thread:
Lists: 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 by date

Next:From: Paul ThomasDate: 2004-08-24 08:20:43
Subject: Re: Connection to a PG 8.0 Beta 1 win32 server
Previous:From: Pablo SDate: 2004-08-24 07:58:18
Subject: Re: Deadlocks -- what can I do about them?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group