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 по дате отправления: