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
>
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? |