Re: pg_hba.conf

Поиск
Список
Период
Сортировка
От C. Bensend
Тема Re: pg_hba.conf
Дата
Msg-id 54543.63.227.74.41.1085628969.squirrel@webmail.stinkweasel.net
обсуждение исходный текст
Ответ на Re: pg_hba.conf  (mike g <mike@thegodshalls.com>)
Ответы Re: pg_hba.conf  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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"

В списке pgsql-admin по дате отправления:

Предыдущее
От: mike g
Дата:
Сообщение: Re: pg_hba.conf
Следующее
От: Laurens Wagemakers
Дата:
Сообщение: Re: PG_DUMP / PG_RESTORE