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

From John R Pierce
Subject Re: PostgreSQL server won't start, corrupt?
Date
Msg-id 5436F394.1020107@hogranch.com
Whole thread Raw
In response to Re: PostgreSQL server won't start, corrupt?  (Raymond O'Donnell <rod@iol.ie>)
Responses Re: PostgreSQL server won't start, corrupt?  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
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



pgsql-general by date:

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