Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-admin by date

Next:From: Cliff WellsDate: 2002-06-26 16:48:41
Subject: Re: error while loading shared libraries:
Previous:From: Nick FankhauserDate: 2002-06-26 14:04:32
Subject: Re: Missing or Erroneous pg_hba.conf file

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group