From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unable to (re) start PostgreSQL 8.4.4/WinXP |
Date: | 2010-06-14 16:54:35 |
Message-ID: | 4C165ECB.9030302@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Abbas | 2010-06-14 17:41:02 | Re: Trigger get dissabled |
Previous Message | Merlin Moncure | 2010-06-14 15:29:09 | Re: Is there a way to backup Postgres via SQL commands? |