Re: Unable to (re) start PostgreSQL 8.4.4/WinXP - Mailing list pgsql-general

From John R Pierce
Subject Re: Unable to (re) start PostgreSQL 8.4.4/WinXP
Date
Msg-id 4C165ECB.9030302@hogranch.com
Whole thread Raw
In response to Re: Unable to (re) start PostgreSQL 8.4.4/WinXP  (kunalashar <kunalashar@aol.com>)
List 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 by date:

Previous
From: kunalashar
Date:
Subject: Re: Unable to (re) start PostgreSQL 8.4.4/WinXP
Next
From: Abbas
Date:
Subject: Re: Trigger get dissabled