Re: PostgreSQL server won't start, corrupt?

From: Rob Flemming <robf(dot)42(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: John R Pierce <pierce(at)hogranch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL server won't start, corrupt?
Date: 2014-10-09 21:50:35
Message-ID: CAFLXUugTtQqoMaPdTv12EaO_yUyzy22xBkTa9hF5mdo3a1s2dA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2014-10-09 22:00:20 Re: PostgreSQL server won't start, corrupt?
Previous Message Adrian Klaver 2014-10-09 21:41:15 Re: PostgreSQL server won't start, corrupt?