Re: Unable to (re) start PostgreSQL 8.4.4/WinXP

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Unable to (re) start PostgreSQL 8.4.4/WinXP
Дата
Msg-id 4C165ECB.9030302@hogranch.com
обсуждение исходный текст
Ответ на Re: Unable to (re) start PostgreSQL 8.4.4/WinXP  (kunalashar <kunalashar@aol.com>)
Список pgsql-general
kunalashar wrote:
> The pg_log files contain, rather inexplicably:
>
> 2010-06-14 09:47:32 IST LOG:  invalid IP mask "trust": Unknown host
> 2010-06-14 09:47:32 IST CONTEXT:  line 74 of configuration file
> "E:/Data/PostgreSQL/8.4/data/pg_hba.conf"
> 2010-06-14 09:47:32 IST FATAL:  could not load pg_hba.conf
>
>
> 2010-06-14 09:45:06 IST LOG:  invalid IP mask "md5": Unknown host
> 2010-06-14 09:45:06 IST CONTEXT:  line 74 of configuration file
> "E:/Data/PostgreSQL/8.4/data/pg_hba.conf"
> 2010-06-14 09:45:06 IST FATAL:  could not load pg_hba.conf
>
>
> 2010-06-14 09:45:06 IST LOG:  invalid IP mask "md5": Unknown host
> 2010-06-14 09:45:06 IST CONTEXT:  line 74 of configuration file
> "E:/Data/PostgreSQL/8.4/data/pg_hba.conf"
> 2010-06-14 09:45:06 IST FATAL:  could not load pg_hba.conf
>
>
> 2010-06-14 09:37:36 IST LOG:  invalid connection type "all
>     "
> 2010-06-14 09:37:36 IST CONTEXT:  line 70 of configuration file
> "E:/Data/PostgreSQL/8.4/data/pg_hba.conf"
> 2010-06-14 09:37:36 IST LOG:  invalid CIDR mask in address "192.168.0.0/255"
> 2010-06-14 09:37:36 IST CONTEXT:  line 74 of configuration file
> "E:/Data/PostgreSQL/8.4/data/pg_hba.conf"
> 2010-06-14 09:37:36 IST FATAL:  could not load pg_hba.conf
>
>

sounds liek there's more than just the entry you gave us before...

> My pg_hba.conf file has the following line:
> host   all   all   192.168.0.1/24   trust
>


which, btw, is probably wrong.    with a mask of /24 (which is
equivalent to 255.255.255.0, eg 24 '1's), the IP part would have to be
192.168.0.0 (as in this context, thats the network number).    your last
error, /255 is under no conditions a valid CIDR mask length.


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

Предыдущее
От: kunalashar
Дата:
Сообщение: Re: Unable to (re) start PostgreSQL 8.4.4/WinXP
Следующее
От: Abbas
Дата:
Сообщение: Re: Trigger get dissabled