Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL server won't start, corrupt? - Mailing list pgsql-general

From Rob Flemming
Subject Re: PostgreSQL server won't start, corrupt?
Date
Msg-id CAFLXUugTtQqoMaPdTv12EaO_yUyzy22xBkTa9hF5mdo3a1s2dA@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL server won't start, corrupt?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: PostgreSQL server won't start, corrupt?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
Indeed!  

I'd also note that I was unable to fix the file with Notepad++ because I was saving it with 
"Encoding > Encode in UTF-8" 
rather than 
">Encode in UTF-8 without BOM"
The "BOM" was the bit causing the trouble at the start of the file.

Thanks again,
Rob

On 9 October 2014 14:41, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 10/09/2014 02:37 PM, Rob Flemming wrote:
You were right!  (Of course, you knew that.)

I typed a new pg_hba.conf from scratch without all the comments, i.e.
only the connection strings, it worked.

Thank you 'Community'!

(Doh!  My kids think I'm so smart because I work on computers, some day
they'll discover the truth. Now to spend the afternoon backing up that
data...)


 The moral to this story is never let Notepad near anything you care about. If you have to use one of the MS apps to edit a text file use Wordpad, otherwise stick with Notepad++.




--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL server won't start, corrupt?
Next
From: John R Pierce
Date:
Subject: Re: PostgreSQL server won't start, corrupt?