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

From Tom Lane
Subject Re: Require Assistance Solving Problem - erroneous pg_hba.conf
Date
Msg-id 10547.1050590455@sss.pgh.pa.us
Whole thread Raw
In response to Require Assistance Solving Problem - erroneous pg_hba.conf  ("Greg Kelley" <gkelley@britannicaviation.com>)
Responses Re: Require Assistance Solving Problem - erroneous pg_hba.conf  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
"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.

            regards, tom lane


pgsql-admin by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: floating point exception! with contrib/xml
Next
From: Bruce Momjian
Date:
Subject: Re: Require Assistance Solving Problem - erroneous pg_hba.conf