Re: PostgreSQL server won't start, corrupt?

Поиск
Список
Период
Сортировка
От Rob Flemming
Тема Re: PostgreSQL server won't start, corrupt?
Дата
Msg-id CAFLXUugTtQqoMaPdTv12EaO_yUyzy22xBkTa9hF5mdo3a1s2dA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL server won't start, corrupt?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: PostgreSQL server won't start, corrupt?  (John R Pierce <pierce@hogranch.com>)
Список 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.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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: PostgreSQL server won't start, corrupt?
Следующее
От: John R Pierce
Дата:
Сообщение: Re: PostgreSQL server won't start, corrupt?