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

Re: pg_hba.conf

From: Mike G <mike(at)thegodshalls(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_hba.conf
Date: 2004-05-28 01:54:44
Message-ID: 20040528015444.GA4803@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-admin
Thank you to all who replied with the additional info.
On Thu, May 27, 2004 at 09:35:06AM -0400, Tom Lane wrote:
> "C. Bensend" <benny(at)bennyvision(dot)com> writes:
> >> I had setup my pg_hba.conf originally like this:
> >> host   all     all     10.15.0.0       255.255.255.0   trust
> >> 
> >> I was under the impression that the .0 was supposed to be equivalent to
> >> a wildcard entry so that any connection from 10.15 would be able to
> >> connect.  This was not so.  By changing my pg_hba.conf to this:
> 
> > Yes, when your subnet mask is set for a /24, that's correct.
> 
> To expand a bit: the correct way of letting in a /16 would be
> 
> host   all     all     10.15.0.0       255.255.0.0   trust
> 
> In recent PG releases (7.4.*, not sure about 7.3) you could also write
> 
> host   all     all     10.15.0.0/16   trust
> 
> 			regards, tom lane

In response to

pgsql-admin by date

Next:From: Renney ThomasDate: 2004-05-28 03:05:33
Subject: Compiling problems with 7.4.2
Previous:From: Sally SallyDate: 2004-05-27 21:16:46
Subject: pg_restore quick question

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