Re: Setting up security for development

Поиск
Список
Период
Сортировка
От Michael Swierczek
Тема Re: Setting up security for development
Дата
Msg-id 68b5b5880907231315g5160020bte5ebbdb92964fa@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Setting up security for development  (Michael Gould <mgould@intermodalsoftwaresolutions.net>)
Ответы Re: Setting up security for development  (Saul Lozano <lozano.saul@gmail.com>)
Список pgsql-novice
I'm no expert, but I believe the format of your pg_hba.conf is wrong.

>>
>> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
>>
>> # IPv4 local connections:
>> #host    all         all         127.0.0.1/32
>> host    all         all         192.168.1.0/32 255.255.255.0        trust
>> # IPv6 local connections:
>> host    all         all         ::1/128               md5
>>
The error is this
host    all         all         192.168.1.0/32 255.255.255.0        trust

I think you want
192.168.1.0/24    OR
192.168.1.0 255.255.255.0

I don't know if specifying both would work.
Also /32 means that all four groups of numbers must match, so you can
only connect from the exact IP address 192.168.1.0.
/8  means you can connect from 192.anything
/16 means 192.168.anything
/24 means 192.168.1.anything
/32 means 192.168.1.0 exact match

-Mike Swierczek

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

Предыдущее
От: Michael Swierczek
Дата:
Сообщение: SSL root.crt read problem for Postgres 8.4
Следующее
От: "Net Tree Inc."
Дата:
Сообщение: Question on Load balancing