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

Re: pg_hba.conf

From: "C(dot) Bensend" <benny(at)bennyvision(dot)com>
To: mike(at)thegodshalls(dot)com
Cc: lsanchez(at)ameritrade(dot)com, pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_hba.conf
Date: 2004-05-27 03:35:47
Message-ID: 54543.63.227.74.41.1085628969.squirrel@webmail.stinkweasel.net (view raw or flat)
Thread:
Lists: pgsql-admin
> 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:
>
> host   all     all    10.15.13.0      255.255.255.0    trust
>
> I was able to connect successfully.  The .0 works as a wildcard entry
> for the last part but not the one prior.

Yes, when your subnet mask is set for a /24, that's correct.

Your first attempt above allowed connections for anything in the
10.15.0/24 subnet (which 10.15.13 is not a part of).

Benny


-- 
"Oh, the Jedis are going to feel this one!"       -- Professor Farnsworth,
                                                     "Futurama"

In response to

Responses

pgsql-admin by date

Next:From: Laurens WagemakersDate: 2004-05-27 05:31:59
Subject: Re: PG_DUMP / PG_RESTORE
Previous:From: mike gDate: 2004-05-27 03:16:15
Subject: Re: pg_hba.conf

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