Re: Require Assistance Solving Problem - erroneous pg_hba.conf - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Require Assistance Solving Problem - erroneous pg_hba.conf
Date
Msg-id 200304171444.h3HEiX316284@candle.pha.pa.us
Whole thread Raw
In response to Re: Require Assistance Solving Problem - erroneous pg_hba.conf  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tom Lane wrote:
> "Greg Kelley" <gkelley@britannicaviation.com> writes:
> > pgsql log shows:
>
> > FATAL:  Missing or erroneous pg_hba.conf file, see postmaster log for
> > details
> > "OG:  parse_hba: invalid syntax in pg_hba.conf file at line 31, token "
>
> > Even the log entry doesn't look right - double quotes - and the .conf file
> > certainly doesn't have 31 lines!
>
> Indeed.  I think it's a Windows-newline issue: you probably edited the
> config file with something that put in \r\n instead of \n.  The
> overstruck LOG is a dead giveaway...
>
> I thought we had fixed the various config file parsers to be reasonably
> impervious to stray \r's, but you may have found a corner case where
> it's not recognized as whitespace.  Try getting rid of the \r's.

Also, please don't wait a week and have your users frustrated before
asking for assistance --- we are here to help.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Require Assistance Solving Problem - erroneous pg_hba.conf
Next
From: Murthy Kambhampaty
Date:
Subject: Re: Require Assistance Solving Problem - erroneous pg_hba