Search Postgresql Archives

Re: PostgreSQL server won't start, corrupt?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux