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

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.

In response to

Browse pgsql-general by date

  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?