Re: PostgreSQL server won't start, corrupt?

On 10/9/2014 1:41 PM, Raymond O'Donnell wrote:
>> >The messages in the log file are: 2014-10-09 12:59:40 PDT LOG:
>> >invalid connection type "" 2014-10-09 12:59:40 PDT CONTEXT: line 1
>> >of configuration file "C:/postgres/pg_hba.conf" 2014-10-09 12:59:40
>> >PDT FATAL: could not load pg_hba.conf
> Well, the error messages seem to indicate that there's a problem with
> pg_hba.conf, so I'd start by reversing whatever you did there and seeing
> if that fixes it.

OH! Notepad probably saved it as Windows Unicode, which is UTF16,
and put a utf16 byte marker in the first bytes of the file.

Try using notepad++ (open source freeware editor for windows) and make
sure you save it as UTF8 or plain ascii, NOT as UTF16 aka unicode.

--
john r pierce 37N 122W
somewhere on the middle of the left coast