Re: Missing or Erroneous pg_hba.conf file

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: acchung(at)mit(dot)edu, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Missing or Erroneous pg_hba.conf file
Date: 2002-06-26 14:54:31
Message-ID: 2366.1025103271@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)uk> writes:
> On Tue, 25 Jun 2002 acchung(at)mit(dot)edu wrote:
>> How do I get my pg_hba.conf file back to normal?

> Did wordpad perhaps automatically add a .txt extension?

I'm betting it added CR/LF (\r\n) newlines. A quick look at the sources
shows that PG does not like \r in pg_hba.conf. I've made it more
forgiving for 7.3, but for now, you'd better resave with Unix-style
newlines (\n only).

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Cliff Wells 2002-06-26 16:48:41 Re: error while loading shared libraries: libpq++.so.4
Previous Message Nick Fankhauser 2002-06-26 14:04:32 Re: Missing or Erroneous pg_hba.conf file